Edit File: keywords.result
drop table if exists t1; create table t1 (time time, date date, timestamp timestamp, quarter int, week int, year int, timestampadd int, timestampdiff int); insert into t1 values ("12:22:22","97:02:03","1997-01-02",1,2,3,4,5); select * from t1; time date timestamp quarter week year timestampadd timestampdiff 12:22:22 1997-02-03 1997-01-02 00:00:00 1 2 3 4 5 select t1.time+0,t1.date+0,t1.timestamp+0,concat(date," ",time), t1.quarter+t1.week, t1.year+timestampadd, timestampdiff from t1; t1.time+0 t1.date+0 t1.timestamp+0 concat(date," ",time) t1.quarter+t1.week t1.year+timestampadd timestampdiff 122222 19970203 19970102000000 1997-02-03 12:22:22 3 7 5 drop table t1; create table events(binlog int); insert into events values(1); select events.binlog from events; binlog 1 drop table events; create procedure p1() begin declare n int default 2; authors: while n > 0 do set n = n -1; end while authors; end| create procedure p2() begin declare n int default 2; contributors: while n > 0 do set n = n -1; end while contributors; end| drop procedure p1; drop procedure p2; create table t1 (connection int, b int); create procedure p1() begin declare connection int; select max(t1.connection) into connection from t1; select concat("max=",connection) 'p1'; end| insert into t1 (connection) values (1); call p1(); p1 max=1 drop procedure p1; drop table t1; CREATE TABLE slow (slow INT, general INT, master_heartbeat_period INT, ignore_server_ids INT); INSERT INTO slow(slow, general, master_heartbeat_period, ignore_server_ids) VALUES (1,2,3,4), (5,6,7,8); INSERT INTO slow(slow, general, master_heartbeat_period) VALUES (1,2,3), (5,6,7); INSERT INTO slow(slow, general) VALUES (1,2), (5,6); INSERT INTO slow(slow) VALUES (1), (5); SELECT slow, general, master_heartbeat_period, ignore_server_ids FROM slow ORDER BY slow; slow general master_heartbeat_period ignore_server_ids 1 2 3 4 1 2 3 NULL 1 2 NULL NULL 1 NULL NULL NULL 5 6 7 8 5 6 7 NULL 5 6 NULL NULL 5 NULL NULL NULL SELECT slow, general, master_heartbeat_period FROM slow ORDER BY slow; slow general master_heartbeat_period 1 2 3 1 2 3 1 2 NULL 1 NULL NULL 5 6 7 5 6 7 5 6 NULL 5 NULL NULL SELECT slow, master_heartbeat_period FROM slow ORDER BY slow; slow master_heartbeat_period 1 3 1 3 1 NULL 1 NULL 5 7 5 7 5 NULL 5 NULL SELECT slow FROM slow ORDER BY slow; slow 1 1 1 1 5 5 5 5 DROP TABLE slow; CREATE TABLE general (slow INT, general INT, master_heartbeat_period INT, ignore_server_ids INT); INSERT INTO general(slow, general, master_heartbeat_period, ignore_server_ids) VALUES (1,2,3,4), (5,6,7,8); INSERT INTO general(slow, general, master_heartbeat_period) VALUES (1,2,3), (5,6,7); INSERT INTO general(slow, general) VALUES (1,2), (5,6); INSERT INTO general(slow) VALUES (1), (5); SELECT slow, general, master_heartbeat_period, ignore_server_ids FROM general ORDER BY slow; slow general master_heartbeat_period ignore_server_ids 1 2 3 4 1 2 3 NULL 1 2 NULL NULL 1 NULL NULL NULL 5 6 7 8 5 6 7 NULL 5 6 NULL NULL 5 NULL NULL NULL SELECT slow, general, master_heartbeat_period FROM general ORDER BY slow; slow general master_heartbeat_period 1 2 3 1 2 3 1 2 NULL 1 NULL NULL 5 6 7 5 6 7 5 6 NULL 5 NULL NULL SELECT slow, master_heartbeat_period FROM general ORDER BY slow; slow master_heartbeat_period 1 3 1 3 1 NULL 1 NULL 5 7 5 7 5 NULL 5 NULL SELECT slow FROM general ORDER BY slow; slow 1 1 1 1 5 5 5 5 DROP TABLE general; CREATE TABLE master_heartbeat_period (slow INT, general INT, master_heartbeat_period INT, ignore_server_ids INT); INSERT INTO master_heartbeat_period(slow, general, master_heartbeat_period, ignore_server_ids) VALUES (1,2,3,4), (5,6,7,8); INSERT INTO master_heartbeat_period(slow, general, master_heartbeat_period) VALUES (1,2,3), (5,6,7); INSERT INTO master_heartbeat_period(slow, general) VALUES (1,2), (5,6); INSERT INTO master_heartbeat_period(slow) VALUES (1), (5); SELECT slow, general, master_heartbeat_period, ignore_server_ids FROM master_heartbeat_period ORDER BY slow; slow general master_heartbeat_period ignore_server_ids 1 2 3 4 1 2 3 NULL 1 2 NULL NULL 1 NULL NULL NULL 5 6 7 8 5 6 7 NULL 5 6 NULL NULL 5 NULL NULL NULL SELECT slow, general, master_heartbeat_period FROM master_heartbeat_period ORDER BY slow; slow general master_heartbeat_period 1 2 3 1 2 3 1 2 NULL 1 NULL NULL 5 6 7 5 6 7 5 6 NULL 5 NULL NULL SELECT slow, master_heartbeat_period FROM master_heartbeat_period ORDER BY slow; slow master_heartbeat_period 1 3 1 3 1 NULL 1 NULL 5 7 5 7 5 NULL 5 NULL SELECT slow FROM master_heartbeat_period ORDER BY slow; slow 1 1 1 1 5 5 5 5 DROP TABLE master_heartbeat_period; CREATE TABLE ignore_server_ids (slow INT, general INT, master_heartbeat_period INT, ignore_server_ids INT); INSERT INTO ignore_server_ids(slow, general, master_heartbeat_period, ignore_server_ids) VALUES (1,2,3,4), (5,6,7,8); INSERT INTO ignore_server_ids(slow, general, master_heartbeat_period) VALUES (1,2,3), (5,6,7); INSERT INTO ignore_server_ids(slow, general) VALUES (1,2), (5,6); INSERT INTO ignore_server_ids(slow) VALUES (1), (5); SELECT slow, general, master_heartbeat_period, ignore_server_ids FROM ignore_server_ids ORDER BY slow; slow general master_heartbeat_period ignore_server_ids 1 2 3 4 1 2 3 NULL 1 2 NULL NULL 1 NULL NULL NULL 5 6 7 8 5 6 7 NULL 5 6 NULL NULL 5 NULL NULL NULL SELECT slow, general, master_heartbeat_period FROM ignore_server_ids ORDER BY slow; slow general master_heartbeat_period 1 2 3 1 2 3 1 2 NULL 1 NULL NULL 5 6 7 5 6 7 5 6 NULL 5 NULL NULL SELECT slow, master_heartbeat_period FROM ignore_server_ids ORDER BY slow; slow master_heartbeat_period 1 3 1 3 1 NULL 1 NULL 5 7 5 7 5 NULL 5 NULL SELECT slow FROM ignore_server_ids ORDER BY slow; slow 1 1 1 1 5 5 5 5 DROP TABLE ignore_server_ids; CREATE TABLE t1 (slow INT, general INT, ignore_server_ids INT, master_heartbeat_period INT); INSERT INTO t1 VALUES (1,2,3,4); CREATE PROCEDURE p1() BEGIN DECLARE slow INT; DECLARE general INT; DECLARE ignore_server_ids INT; DECLARE master_heartbeat_period INT; SELECT max(t1.slow) INTO slow FROM t1; SELECT max(t1.general) INTO general FROM t1; SELECT max(t1.ignore_server_ids) INTO ignore_server_ids FROM t1; SELECT max(t1.master_heartbeat_period) INTO master_heartbeat_period FROM t1; SELECT slow, general, ignore_server_ids, master_heartbeat_period; END| CREATE PROCEDURE p2() BEGIN DECLARE n INT DEFAULT 2; general: WHILE n > 0 DO SET n = n -1; END WHILE general; SET n = 2; slow: WHILE n > 0 DO SET n = n -1; END WHILE slow; SET n = 2; ignore_server_ids: WHILE n > 0 DO SET n = n -1; END WHILE ignore_server_ids; SET n = 2; master_heartbeat_period: WHILE n > 0 DO SET n = n -1; END WHILE master_heartbeat_period; END| CALL p1(); slow general ignore_server_ids master_heartbeat_period 1 2 3 4 call p2(); DROP PROCEDURE p1; DROP PROCEDURE p2; DROP TABLE t1;
Back to File Manager