Edit File: rpl_relay_space_myisam.result
include/master-slave.inc [connection master] SHOW VARIABLES LIKE 'relay_log_space_limit'; Variable_name Value relay_log_space_limit 0 CREATE TABLE t1 (name varchar(64), age smallint(3))ENGINE=MyISAM; INSERT INTO t1 SET name='Andy', age=31; INSERT INTO t1 SET name='Jacob', age=2; INSERT INTO t1 SET name='Caleb', age=1; ALTER TABLE t1 ADD id int(8) ZEROFILL AUTO_INCREMENT PRIMARY KEY; SELECT * FROM t1 ORDER BY id; name age id Andy 31 00000001 Jacob 2 00000002 Caleb 1 00000003 SELECT * FROM t1 ORDER BY id; name age id Andy 31 00000001 Jacob 2 00000002 Caleb 1 00000003 DROP TABLE t1; include/rpl_end.inc
Back to File Manager