251
251
INSERT INTO db2.t1 (a) SELECT * FROM t2;
252
252
DELETE FROM t1 alias USING t1, t2 alias WHERE t1.a = alias.a;
253
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'alias USING t1, t2 alias WHERE t1.a = alias.a' at line 1
253
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'alias USING t1, t2 alias WHERE t1.a = alias.a' at line 1
254
254
DELETE FROM alias USING t1, t2 alias WHERE t1.a = alias.a;
255
255
DELETE FROM t1, alias USING t1, t2 alias WHERE t1.a = alias.a;
256
256
DELETE FROM t1, t2 USING t1, t2 alias WHERE t1.a = alias.a;
257
257
ERROR 42S02: Unknown table 't2' in MULTI DELETE
258
258
DELETE FROM db1.t1 alias USING db1.t1, db2.t1 alias WHERE db1.t1.a = alias.a;
259
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'alias USING db1.t1, db2.t1 alias WHERE db1.t1.a = alias.a' at line 1
259
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'alias USING db1.t1, db2.t1 alias WHERE db1.t1.a = alias.a' at line 1
260
260
DELETE FROM alias USING db1.t1, db2.t1 alias WHERE db1.t1.a = alias.a;
261
261
DELETE FROM db2.alias USING db1.t1, db2.t1 alias WHERE db1.t1.a = alias.a;
262
262
ERROR 42S02: Unknown table 'alias' in MULTI DELETE