📄 rpl_innodb.result
字号:
stop slave;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;start slave;CREATE TABLE t4 (id INT(5) unsigned NOT NULL auto_increment,name varchar(15) NOT NULL default '',number varchar(35) NOT NULL default 'default',PRIMARY KEY (id),UNIQUE KEY unique_rec (name,number)) ENGINE=InnoDB;LOAD DATAINFILE '../std_data_ln/loaddata_pair.dat' REPLACE INTO TABLE t4 (name,number);SELECT * FROM t4;id name number1 XXX 123452 XXY 12345SELECT * FROM t4;id name number1 XXX 123452 XXY 12345LOAD DATAINFILE '../std_data_ln/loaddata_pair.dat' REPLACE INTO TABLE t4(name,number);SELECT * FROM t4;id name number3 XXX 123454 XXY 12345SELECT * FROM t4;id name number3 XXX 123454 XXY 12345
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -