Error: DELETE FROM t_23andme_addref WHERE id IN ( SELECT min(id) FROM t_23andme_addref GROUP BY rsid HAVING coun ...
Error:
DELETE FROM t_23andme_addref
WHERE id IN ( SELECT min(id) FROM t_23andme_addref GROUP BY rsid
HAVING count(rsid) > 1)
ERROR 1064 (42000): You have an error in your SQL syntax;
DELETE tt FROM t_23andme_addref tt, ( SELECT min(id) AS id FROM t_23andme_addref GROUP BY rsid HAVING count(rsid) > 1) AS b WHERE tt.id = b.id;
原标题:MySQL联表更新插入数据
关键词:MYSQL
*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们:
admin#shaoqun.com
(#换成@)。