Hola;
Porque no lo pruebas tu mismo, yo no me acuerdo ya
use test;
create table t1 (id tinyint);
create table t2 (id tinyint );
insert into t1 (id) values (1),(2),(3),(4),(5), (6),(7),(8),(9),(10);
insert into t2 (id) values (1),(2),(3),(4),(5), (6),(7),(8),(9),(10);
delete t2 from t1 left join t2 on (t1.id=t2.id) where t1.id > 5;
delete t1 from t1 left join t2 on (t1.id=t2.id) where t1.id < 5;
select * from t1;
select * from t2;
Mit freundlichen Grüssen
Thomas Goik
estoy usando la version 3.23 de mysql, queria saber si se puede hacer un
DELETE multitabla?...
2 messages in com.mysql.lists.mysql-esRE: delete multiple
