1 2 3 4 5 6 7 8 9 10 11 12 |
DROP TABLE IF EXISTS t1; CREATE TABLE t1 ( id INT NOT NULL , padding VARCHAR(200) NOT NULL ); INSERT INTO t1 VALUES (1, "I love testing."); INSERT INTO t1 VALUES (2, "I hate testing."); DROP TABLE IF EXISTS t1; CREATE TABLE t1 ( id INT NOT NULL , padding VARCHAR(200) NOT NULL ); INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (1,'I love testing.'); INSERT INTO `test`.`t1` (`id`,`padding`) VALUES (2,'I hate testing.'); SET GLOBAL transaction_log_truncate_debug= true; |