2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
8
select last_insert_id();
11
create table t1(a int not null auto_increment, b int, primary key(a) );
12
load data infile '../std_data_ln/rpl_loaddata.dat' into table t1;
13
select last_insert_id();
16
create temporary table t2 (day date,id int(9),category enum('a','b','c'),name varchar(60));
17
load data infile '../std_data_ln/rpl_loaddata2.dat' into table t2 fields terminated by ',' optionally enclosed by '%' escaped by '@' lines terminated by '\n##\n' starting by '>' ignore 1 lines;
18
create table t3 (day date,id int(9),category enum('a','b','c'),name varchar(60));
19
insert into t3 select * from t2;
26
2003-02-22 2461 b a a a @ % ' " a
27
2003-03-22 2161 c asdf
28
2003-03-22 2416 a bbbbb
30
File Position Binlog_Do_DB Binlog_Ignore_DB
35
create table t1(a int, b int, unique(b));
36
insert into t1 values(1,10);
37
load data infile '../std_data_ln/rpl_loaddata.dat' into table t1;
38
set global sql_slave_skip_counter=1;
41
Slave_IO_State Master_Host Master_User Master_Port Connect_Retry Master_Log_File Read_Master_Log_Pos Relay_Log_File Relay_Log_Pos Relay_Master_Log_File Slave_IO_Running Slave_SQL_Running Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno Last_Error Skip_Counter Exec_Master_Log_Pos Relay_Log_Space Until_Condition Until_Log_File Until_Log_Pos Master_SSL_Allowed Master_SSL_CA_File Master_SSL_CA_Path Master_SSL_Cert Master_SSL_Cipher Master_SSL_Key Seconds_Behind_Master
42
# 127.0.0.1 root MASTER_PORT 1 master-bin.000001 1765 # # master-bin.000001 Yes Yes # 0 0 1765 # None 0 No #
46
load data infile '../std_data_ln/rpl_loaddata.dat' into table t1;
48
change master to master_user='test';
49
change master to master_user='root';
51
Slave_IO_State Master_Host Master_User Master_Port Connect_Retry Master_Log_File Read_Master_Log_Pos Relay_Log_File Relay_Log_Pos Relay_Master_Log_File Slave_IO_Running Slave_SQL_Running Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno Last_Error Skip_Counter Exec_Master_Log_Pos Relay_Log_Space Until_Condition Until_Log_File Until_Log_Pos Master_SSL_Allowed Master_SSL_CA_File Master_SSL_CA_Path Master_SSL_Cert Master_SSL_Cipher Master_SSL_Key Seconds_Behind_Master
52
# 127.0.0.1 root MASTER_PORT 1 master-bin.000001 1800 # # master-bin.000001 No No # 0 0 1800 # None 0 No #
53
set global sql_slave_skip_counter=1;
58
load data infile '../std_data_ln/rpl_loaddata.dat' into table t1;
62
Slave_IO_State Master_Host Master_User Master_Port Connect_Retry Master_Log_File Read_Master_Log_Pos Relay_Log_File Relay_Log_Pos Relay_Master_Log_File Slave_IO_Running Slave_SQL_Running Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno Last_Error Skip_Counter Exec_Master_Log_Pos Relay_Log_Space Until_Condition Until_Log_File Until_Log_Pos Master_SSL_Allowed Master_SSL_CA_File Master_SSL_CA_Path Master_SSL_Cert Master_SSL_Cipher Master_SSL_Key Seconds_Behind_Master
63
# 127.0.0.1 root MASTER_PORT 1 4 # # No No # 0 0 0 # None 0 No #
65
create table t2 (day date,id int(9),category enum('a','b','c'),name varchar(60),
66
unique(day)) engine=MyISAM;
67
load data infile '../std_data_ln/rpl_loaddata2.dat' into table t2 fields
68
terminated by ',' optionally enclosed by '%' escaped by '@' lines terminated by
69
'\n##\n' starting by '>' ignore 1 lines;
70
ERROR 23000: Duplicate entry '2003-03-22' for key 'day'
73
2003-02-22 2461 b a a a @ % ' " a
74
2003-03-22 2161 c asdf
78
2003-02-22 2461 b a a a @ % ' " a
79
2003-03-22 2161 c asdf
80
alter table t2 drop key day;
82
load data infile '../std_data_ln/rpl_loaddata2.dat' into table t2 fields
83
terminated by ',' optionally enclosed by '%' escaped by '@' lines terminated by
84
'\n##\n' starting by '>' ignore 1 lines;
85
ERROR 23000: Duplicate entry '2003-03-22' for key 'day'