rpl_loaddata.result 888 Bytes
Newer Older
1
stop slave;
2 3 4 5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
reset master;
reset slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
6
start slave;
7 8
create table t1(a int not null auto_increment, b int, primary key(a) );
load data infile '../../std_data/rpl_loaddata.dat' into table t1;
9
create temporary table t2 (day date,id int(9),category enum('a','b','c'),name varchar(60));
10
load data infile '../../std_data/rpl_loaddata2.dat' into table t2 fields terminated by ',' optionally enclosed by '%' escaped by '@' lines terminated by '\n##\n' starting by '>' ignore 1 lines;
11 12
create table t3 (day date,id int(9),category enum('a','b','c'),name varchar(60));
insert into t3 select * from t2;
13 14 15 16
select * from t1;
a	b
1	10
2	15
17 18 19 20 21
select * from t3;
day	id	category	name
2003-02-22	2461	b	a a a @ %  ' " a
2003-03-22	2161	c	asdf
2003-04-22	2416	a	bbbbb
22
drop table t1;
23 24
drop table t2;
drop table t3;