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; reset master; create table t1(n char(30)); set @i1:=12345678901234, @i2:=-12345678901234, @i3:=0, @i4:=-1; set @s1:='This is a test', @r1:=12.5, @r2:=-12.5; set @n1:=null; set @s2:='', @s3:='abc\'def', @s4:= 'abc\\def', @s5:= 'abc''def'; insert into t1 values (@i1), (@i2), (@i3), (@i4); insert into t1 values (@r1), (@r2); insert into t1 values (@s1), (@s2), (@s3), (@s4), (@s5); insert into t1 values (@n1); insert into t1 values (@n2); insert into t1 values (@a:=0), (@a:=@a+1), (@a:=@a+1); insert into t1 values (@a+(@b:=@a+1)); set @q:='abc'; insert t1 values (@q), (@q:=concat(@q, 'n1')), (@q:=concat(@q, 'n2')); set @a:=5; insert into t1 values (@a),(@a); insert into t1 values (@a),(@a),(@a*5); select * from t1; n 12345678901234 -12345678901234 0 -1 12.5 -12.5 This is a test abc'def abc\def abc'def NULL NULL 0 1 2 5 abc abcn1 abcn1n2 5 5 NULL NULL NULL select * from t1; n 12345678901234 -12345678901234 0 -1 12.5 -12.5 This is a test abc'def abc\def abc'def NULL NULL 0 1 2 5 abc abcn1 abcn1n2 5 5 NULL NULL NULL show binlog events from 96; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000001 96 Query 1 187 use `test`; create table t1(n char(30)) slave-bin.000001 187 User var 2 230 @`i1`=12345678901234 slave-bin.000001 230 User var 2 273 @`i2`=-12345678901234 slave-bin.000001 273 User var 2 316 @`i3`=0 slave-bin.000001 316 User var 2 359 @`i4`=-1 slave-bin.000001 359 Query 1 471 use `test`; insert into t1 values (@i1), (@i2), (@i3), (@i4) slave-bin.000001 471 User var 2 510 @`r1`=12.5 slave-bin.000001 510 User var 2 549 @`r2`=-12.5 slave-bin.000001 549 Query 1 647 use `test`; insert into t1 values (@r1), (@r2) slave-bin.000001 647 User var 2 696 @`s1`=_latin1 0x5468697320697320612074657374 COLLATE latin1_swedish_ci slave-bin.000001 696 User var 2 731 @`s2`=_latin1 "" COLLATE latin1_swedish_ci slave-bin.000001 731 User var 2 773 @`s3`=_latin1 0x61626327646566 COLLATE latin1_swedish_ci slave-bin.000001 773 User var 2 815 @`s4`=_latin1 0x6162635C646566 COLLATE latin1_swedish_ci slave-bin.000001 815 User var 2 857 @`s5`=_latin1 0x61626327646566 COLLATE latin1_swedish_ci slave-bin.000001 857 Query 1 976 use `test`; insert into t1 values (@s1), (@s2), (@s3), (@s4), (@s5) slave-bin.000001 976 User var 2 1002 @`n1`=NULL slave-bin.000001 1002 Query 1 1093 use `test`; insert into t1 values (@n1) slave-bin.000001 1093 User var 2 1119 @`n2`=NULL slave-bin.000001 1119 Query 1 1210 use `test`; insert into t1 values (@n2) slave-bin.000001 1210 Query 1 1327 use `test`; insert into t1 values (@a:=0), (@a:=@a+1), (@a:=@a+1) slave-bin.000001 1327 User var 2 1369 @`a`=2 slave-bin.000001 1369 Query 1 1470 use `test`; insert into t1 values (@a+(@b:=@a+1)) slave-bin.000001 1470 User var 2 1507 @`q`=_latin1 0x616263 COLLATE latin1_swedish_ci slave-bin.000001 1507 Query 1 1640 use `test`; insert t1 values (@q), (@q:=concat(@q, 'n1')), (@q:=concat(@q, 'n2')) slave-bin.000001 1640 User var 2 1682 @`a`=5 slave-bin.000001 1682 Query 1 1777 use `test`; insert into t1 values (@a),(@a) slave-bin.000001 1777 User var 2 1802 @`a`=NULL slave-bin.000001 1802 Query 1 1904 use `test`; insert into t1 values (@a),(@a),(@a*5) drop table t1; stop slave;