Edit File: rpl_row_001.result
include/master-slave.inc [connection master] CREATE TABLE t1 (word CHAR(20) NOT NULL); LOAD DATA INFILE 'LOAD_FILE' INTO TABLE t1; LOAD DATA INFILE 'LOAD_FILE' INTO TABLE t1; SELECT * FROM t1 ORDER BY word LIMIT 10; word Aarhus Aarhus Aarhus Aarhus Aaron Aaron Aaron Aaron Ababa Ababa STOP SLAVE; SET PASSWORD FOR root@"localhost" = PASSWORD('foo'); START SLAVE; SET PASSWORD FOR root@"localhost" = PASSWORD(''); CREATE TABLE t3(n INT); INSERT INTO t3 VALUES(1),(2); SELECT * FROM t3 ORDER BY n; n 1 2 SELECT SUM(LENGTH(word)) FROM t1; SUM(LENGTH(word)) 1022 DROP TABLE t1,t3; CREATE TABLE t1 (n INT) ENGINE=MYISAM; RESET MASTER; STOP SLAVE; RESET SLAVE; SELECT COUNT(*) FROM t1; COUNT(*) 5000 LOCK TABLES t1 READ; START SLAVE; UNLOCK TABLES; SELECT COUNT(*) FROM t1; COUNT(*) 5000 DROP TABLE t1; CREATE TABLE t1 (n INT); INSERT INTO t1 VALUES(3456); SELECT n FROM t1; n 3456 DROP TABLE t1; include/rpl_end.inc
Back to File Manager