2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
8
create database mysqltest_from;
10
create database mysqltest_to;
12
drop table if exists a;
13
CREATE TABLE a (i INT);
14
INSERT INTO a VALUES(1);
15
DELETE alias FROM a alias WHERE alias.i=1;
18
insert into a values(2),(3);
19
delete alias FROM a alias where alias.i=2;
27
create table t1 (a int primary key);
28
create table t2 (a int);
29
insert into t1 values (1);
30
insert into t2 values (1);
31
delete t1.* from t1, t2 where t1.a = t2.a;
38
ERROR 42S02: Table 'mysqltest_to.t1' doesn't exist
40
ERROR 42S02: Table 'mysqltest_to.t2' doesn't exist
42
drop database mysqltest_from;
44
drop database mysqltest_to;