194
194
SELECT * FROM t1;
197
DROP TABLE IF EXISTS t1,t2;
198
DROP FUNCTION IF EXISTS f1;
199
CREATE TEMPORARY TABLE t1 (a INT);
200
CREATE TEMPORARY TABLE t2 LIKE t1;
201
CREATE FUNCTION f1() RETURNS INT
205
INSERT INTO t2 SELECT * FROM t1;
206
INSERT INTO t1 SELECT f1();
207
CREATE TABLE t3 SELECT * FROM t1;
208
INSERT INTO t1 SELECT f1();
209
UPDATE t1,t2 SET t1.a = t2.a;
210
INSERT INTO t2 SELECT f1();