DELETE FROM t_detail_type d,t_goods g
FROM t_detail_type
LEFT JOIN t_goods
ON t_detail_type.d_id='dt012' AND t_goods.g_kind_id='dt012'mysql
FROM t_detail_type
LEFT JOIN t_goods
ON t_detail_type.d_id='dt012' AND t_goods.g_kind_id='dt012'mysql
调试欢乐多
这样写也不对
DELETE FROM t_goods t,t_detail_type d
WHERE d.d_id='dt012' AND t.g_kind_id=d.d_id一定要写多条语句删除吗?
FROM t_detail_type
LEFT JOIN t_goods
ON t_detail_type.d_id='dt012' AND t_goods.g_kind_id='dt012'
DELETE FROM t_detail_type WHERE d_id='dt012' AND EXISTS (SELECT 1 FROM t_goods WHERE g_kind_id=t_detail_type.d_id)
DELETE t1, t2 FROM t1, t2, t3 WHERE t1.id=t2.id AND t2.id=t3.id;