Edit File: rpl_user_variables.result
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); select * from t1 where n = '<nonexistant>'; n insert into t1 values (@a),(@a),(@a*5); SELECT * FROM t1 ORDER BY n; n NULL NULL NULL NULL NULL -1 -12.5 -12345678901234 0 0 1 12.5 12345678901234 2 5 5 5 abc abc'def abc'def abcn1 abcn1n2 abc\def This is a test SELECT * FROM t1 ORDER BY n; n NULL NULL NULL NULL NULL -1 -12.5 -12345678901234 0 0 1 12.5 12345678901234 2 5 5 5 abc abc'def abc'def abcn1 abcn1n2 abc\def This is a test insert into t1 select * FROM (select @var1 union select @var2) AS t2; drop table t1; stop slave;
Back to File Manager