mysql表中存在多条相同数据,去重方法。
mysql的delete有以下几个语法注意:
1、不支持limit
2、不支持子查询
SELECT * FROM bank_info c
WHERE id IN
(
SELECT * FROM
(
SELECT id FROM bank_info a
WHERE
(
a.bank_num IN (SELECT bank_num FROM bank_info GROUP BY bank_num HAVING COUNT(*) > 1)
AND
a.create_time NOT IN (SELECT MIN(create_time) FROM bank_info GROUP BY bank_num HAVING COUNT(*) > 1)
)
) e
)