delete from legend le where (le.year,le.date) in (select year,date from legend group by year,date having count(*) > 1) and id not in (SELECT min(id) FROM legend GROUP BY YEAR, date HAVING count(*) > 1) 查处重复字段保留最小id号其他重复部分删除~~~
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'le
where (le.year,le.date) in (select year,date from legend group by y' at line 1
执行报错~~~~求解决方法~~~
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'le
where (le.year,le.date) in (select year,date from legend group by y' at line 1
执行报错~~~~求解决方法~~~
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货