2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
9
CREATE TABLE t1 (b CHAR(10));
15
LOAD DATA INFILE FILENAME
16
SELECT COUNT(*) FROM t1;
20
Log_name Pos Event_type Server_id End_log_pos Info
21
master-bin.000001 # Format_desc 1 # Server ver: #
22
master-bin.000001 # Query 1 # use `test`; CREATE TABLE t1 (b CHAR(10))
23
master-bin.000001 # Begin_load_query 1 # ;file_id=#;block_len=#
24
master-bin.000001 # Execute_load_query 1 # use `test`; LOAD DATA INFILE FILENAME ;file_id=#
27
SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1;
29
SELECT COUNT(*) FROM t1;