mysql同时删除多表关联数据

删除a表,b表相同的id字段

“delete a,b from a left join b on a.id = b.id where a.id= ‘xx’”;

删除全部匹配的
delete a from a,b where t1.id=t2.id

  1. 找机会爆你菊花。

  1. No trackbacks yet.