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