mysq删除多条

参考：http://www.jb51.net/article/60926.htm

错误的写法

DELETE FROM anrong_share_info  WHERE anrong_share_id IN (

SELECT anrong_share_id FROM anrong_share_info GROUP BY loan_id HAVING COUNT(*)>1

);

正确的写法：

DELETE FROM anrong_share_info  WHERE anrong_share_id IN (
SELECT ab.anrong_share_id FROM(
SELECT anrong_share_id FROM anrong_share_info GROUP BY loan_id HAVING COUNT(*)>1
) ab
);