你的位置:首页 > 软件开发 > 数据库 > MySQL联表更新插入数据

MySQL联表更新插入数据

发布时间:2016-01-26 11:00:08
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 (#换成@)。