📄 rpl_row_tabledefs.result

📁 开启mysql的远程连接的方法 mysql-noinstall-5.1.6-alpha-win32.zip
💻 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 t1 (a INT PRIMARY KEY, b INT) ENGINE=myisam;CREATE TABLE t2 (a INT PRIMARY KEY, b INT) ENGINE=myisam;CREATE TABLE t3 (a INT PRIMARY KEY, b INT) ENGINE=myisam;CREATE TABLE t4 (a INT) ENGINE=myisam;CREATE TABLE t5 (a INT, b INT, c INT) ENGINE=myisam;CREATE TABLE t6 (a INT, b INT, c INT) ENGINE=myisam;CREATE TABLE t9 (a INT PRIMARY KEY) ENGINE=myisam;ALTER TABLE t1 ADD x INT DEFAULT 42;ALTER TABLE t2 ADD x INT DEFAULT 42 AFTER a;ALTER TABLE t3 ADD x INT DEFAULT 42 FIRST;ALTER TABLE t4 MODIFY a FLOAT;ALTER TABLE t5 MODIFY b FLOAT;ALTER TABLE t6 MODIFY c FLOAT;INSERT INTO t9 VALUES (1);INSERT INTO t1 VALUES (1,2);SHOW SLAVE STATUS;Slave_IO_State	#Master_Host	127.0.0.1Master_User	rootMaster_Port	MASTER_PORTConnect_Retry	1Master_Log_File	master-bin.000001Read_Master_Log_Pos	1042Relay_Log_File	#Relay_Log_Pos	#Relay_Master_Log_File	master-bin.000001Slave_IO_Running	YesSlave_SQL_Running	NoReplicate_Do_DB	Replicate_Ignore_DB	Replicate_Do_Table	Replicate_Ignore_Table	Replicate_Wild_Do_Table	Replicate_Wild_Ignore_Table	Last_Errno	1454Last_Error	Table width mismatch - received 2 columns, test.t1 has 3 columnsSkip_Counter	0Exec_Master_Log_Pos	968Relay_Log_Space	#Until_Condition	NoneUntil_Log_File	Until_Log_Pos	0Master_SSL_Allowed	NoMaster_SSL_CA_File	Master_SSL_CA_Path	Master_SSL_Cert	Master_SSL_Cipher	Master_SSL_Key	Seconds_Behind_Master	#SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2;START SLAVE;INSERT INTO t9 VALUES (2);INSERT INTO t2 VALUES (2,4);SHOW SLAVE STATUS;Slave_IO_State	#Master_Host	127.0.0.1Master_User	rootMaster_Port	MASTER_PORTConnect_Retry	1Master_Log_File	master-bin.000001Read_Master_Log_Pos	1185Relay_Log_File	#Relay_Log_Pos	#Relay_Master_Log_File	master-bin.000001Slave_IO_Running	YesSlave_SQL_Running	NoReplicate_Do_DB	Replicate_Ignore_DB	Replicate_Do_Table	Replicate_Ignore_Table	Replicate_Wild_Do_Table	Replicate_Wild_Ignore_Table	Last_Errno	1454Last_Error	Table width mismatch - received 2 columns, test.t2 has 3 columnsSkip_Counter	0Exec_Master_Log_Pos	1111Relay_Log_Space	#Until_Condition	NoneUntil_Log_File	Until_Log_Pos	0Master_SSL_Allowed	NoMaster_SSL_CA_File	Master_SSL_CA_Path	Master_SSL_Cert	Master_SSL_Cipher	Master_SSL_Key	Seconds_Behind_Master	#SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2;START SLAVE;INSERT INTO t9 VALUES (3);INSERT INTO t3 VALUES (3,6);SHOW SLAVE STATUS;Slave_IO_State	#Master_Host	127.0.0.1Master_User	rootMaster_Port	MASTER_PORTConnect_Retry	1Master_Log_File	master-bin.000001Read_Master_Log_Pos	1328Relay_Log_File	#Relay_Log_Pos	#Relay_Master_Log_File	master-bin.000001Slave_IO_Running	YesSlave_SQL_Running	NoReplicate_Do_DB	Replicate_Ignore_DB	Replicate_Do_Table	Replicate_Ignore_Table	Replicate_Wild_Do_Table	Replicate_Wild_Ignore_Table	Last_Errno	1454Last_Error	Table width mismatch - received 2 columns, test.t3 has 3 columnsSkip_Counter	0Exec_Master_Log_Pos	1254Relay_Log_Space	#Until_Condition	NoneUntil_Log_File	Until_Log_Pos	0Master_SSL_Allowed	NoMaster_SSL_CA_File	Master_SSL_CA_Path	Master_SSL_Cert	Master_SSL_Cipher	Master_SSL_Key	Seconds_Behind_Master	#SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2;START SLAVE;INSERT INTO t9 VALUES (4);INSERT INTO t4 VALUES (4);SHOW SLAVE STATUS;Slave_IO_State	#Master_Host	127.0.0.1Master_User	rootMaster_Port	MASTER_PORTConnect_Retry	1Master_Log_File	master-bin.000001Read_Master_Log_Pos	1466Relay_Log_File	#Relay_Log_Pos	#Relay_Master_Log_File	master-bin.000001Slave_IO_Running	YesSlave_SQL_Running	NoReplicate_Do_DB	Replicate_Ignore_DB	Replicate_Do_Table	Replicate_Ignore_Table	Replicate_Wild_Do_Table	Replicate_Wild_Ignore_Table	Last_Errno	1454Last_Error	Column 0 type mismatch - received type 3, test.t4 has type 4Skip_Counter	0Exec_Master_Log_Pos	1397Relay_Log_Space	#Until_Condition	NoneUntil_Log_File	Until_Log_Pos	0Master_SSL_Allowed	NoMaster_SSL_CA_File	Master_SSL_CA_Path	Master_SSL_Cert	Master_SSL_Cipher	Master_SSL_Key	Seconds_Behind_Master	#SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2;START SLAVE;INSERT INTO t9 VALUES (5);INSERT INTO t5 VALUES (5,10,25);SHOW SLAVE STATUS;Slave_IO_State	#Master_Host	127.0.0.1Master_User	rootMaster_Port	MASTER_PORTConnect_Retry	1Master_Log_File	master-bin.000001Read_Master_Log_Pos	1614Relay_Log_File	#Relay_Log_Pos	#Relay_Master_Log_File	master-bin.000001Slave_IO_Running	YesSlave_SQL_Running	NoReplicate_Do_DB	Replicate_Ignore_DB	Replicate_Do_Table	Replicate_Ignore_Table	Replicate_Wild_Do_Table	Replicate_Wild_Ignore_Table	Last_Errno	1454Last_Error	Column 1 type mismatch - received type 3, test.t5 has type 4Skip_Counter	0Exec_Master_Log_Pos	1535Relay_Log_Space	#Until_Condition	NoneUntil_Log_File	Until_Log_Pos	0Master_SSL_Allowed	NoMaster_SSL_CA_File	Master_SSL_CA_Path	Master_SSL_Cert	Master_SSL_Cipher	Master_SSL_Key	Seconds_Behind_Master	#SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2;START SLAVE;INSERT INTO t9 VALUES (6);INSERT INTO t6 VALUES (6,12,36);SHOW SLAVE STATUS;Slave_IO_State	#Master_Host	127.0.0.1Master_User	rootMaster_Port	MASTER_PORTConnect_Retry	1Master_Log_File	master-bin.000001Read_Master_Log_Pos	1762Relay_Log_File	#Relay_Log_Pos	#Relay_Master_Log_File	master-bin.000001Slave_IO_Running	YesSlave_SQL_Running	NoReplicate_Do_DB	Replicate_Ignore_DB	Replicate_Do_Table	Replicate_Ignore_Table	Replicate_Wild_Do_Table	Replicate_Wild_Ignore_Table	Last_Errno	1454Last_Error	Column 2 type mismatch - received type 3, test.t6 has type 4Skip_Counter	0Exec_Master_Log_Pos	1683Relay_Log_Space	#Until_Condition	NoneUntil_Log_File	Until_Log_Pos	0Master_SSL_Allowed	NoMaster_SSL_CA_File	Master_SSL_CA_Path	Master_SSL_Cert	Master_SSL_Cipher	Master_SSL_Key	Seconds_Behind_Master	#SET GLOBAL SQL_SLAVE_SKIP_COUNTER=2;START SLAVE;DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t9;
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -