联表删除:
delete t1,t2 from table_name t1 left join t2 on t1.id=t2.id where t1.id=23
(ps:该语句在mysql 5.0之前的版本中不能使用别名)
联表删除:
delete t1,t2 from table_name t1 left join t2 on t1.id=t2.id where t1.id=23
(ps:该语句在mysql 5.0之前的版本中不能使用别名)
转载于:https://www.cnblogs.com/LionheartCGJ/p/7096724.html