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
删除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
淡泊以明志,宁静以致远!
探讨网络世界,闲聊人生百态!
岁月无声,静听小桥流水人家,连神都救不了我,唯独只有网络!
找机会爆你菊花。