diff options
Diffstat (limited to 'mysql-test/t/ins000001.test')
-rw-r--r-- | mysql-test/t/ins000001.test | 12 |
1 files changed, 0 insertions, 12 deletions
diff --git a/mysql-test/t/ins000001.test b/mysql-test/t/ins000001.test deleted file mode 100644 index afcd27ebfca..00000000000 --- a/mysql-test/t/ins000001.test +++ /dev/null @@ -1,12 +0,0 @@ -use test; ---disable_warnings -drop table if exists t1,t2; ---enable_warnings - -create table t1 (email varchar(50)); -insert into t1 values ('sasha@mysql.com'),('monty@mysql.com'), -('foo@hotmail.com'),('foo@aol.com'),('bar@aol.com'); -create table t2(id int not null auto_increment primary key, - t2 varchar(50), unique(t2)); -insert into t2 (t2) select distinct substring(email, locate('@', email)+1) from t1; -select * from t2; |