mysql两张表关联删除某张表数据
解决方法:
以下删除online表的数据,数据不在cash表的都删除
delete a from online a left join cash b on a.checkid=b.checkid where b.checkid is null
向大家推荐《Activiti工作流实战教程》:https://xiaozhuanlan.com/activiti
mysql两张表关联删除某张表数据
解决方法:
以下删除online表的数据,数据不在cash表的都删除
delete a from online a left join cash b on a.checkid=b.checkid where b.checkid is null
有建议,请留言!