1.mysql删除两表联合查询出来的指定记录
DELETE FROM v_vsuch_tag_tmp WHERE id IN (SELECT id FROM (SELECT a.id FROM v_vsuch_tag_tmp a LEFT JOIN v_vsuch_tag b ON a.tagid = b.tagid WHERE b.status < 99 OR b.tagid IS NULL) c)
2.mysql删除重复值
DELETE FROM `v_vsuch_tag_tmp` WHERE id NOT IN (SELECT id FROM (SELECT MAX(id) AS id FROM v_vsuch_tag_tmp GROUP BY (datatype + tagid)) a)

本文固定链接: http://blog.wwllcchf.com/?p=345 | 吴文龙的个人博客