你需要的是否是: delete from table_name where table_name.id=25 ?
没用通用的。所以我还是习惯分开多句del。为了版本间的兼容。
不使用别称也许可以通用。不过何必废这事呢。自己为db class添加一个函数来处理这种关联删除就是了。 delete table_name,table2_name from table_name left join table2_name on table_name.id=table2_name.id where table_name.id=25
赞同楼上的说法, 分开写可以用存储程序, 也可使用 START TRANSACTION; DELETE 1 FROM ....; DELETE 2 FROM ..... COMMIT;
delete from table_name where table_name.id=25
?
delete table_name,table2_name from table_name left join table2_name on table_name.id=table2_name.id where table_name.id=25
分开写可以用存储程序,
也可使用
START TRANSACTION;
DELETE 1 FROM ....;
DELETE 2 FROM .....
COMMIT;