Warning: Trying to access array offset on value of type bool in /www/wwwroot/lvshuige.com/wp-content/plugins/wp-super-cache/wp-cache.php on line 3484
mysql删除重复数据,保留一条 - 信息技术分享

mysql删除重复数据,保留一条

作者: admin 分类: sql 发布时间: 2018-08-16 09:27

mysql删除重复数据,保留一条

delete from data where id not in (select minid from (select min(id) as minid from data group by word) b);

 

如果觉得我的文章对您有用,请随意打赏。您的支持将鼓励我继续创作!


Warning: Undefined variable $aria_req in /www/wwwroot/lvshuige.com/wp-content/themes/JieStyle/comments.php on line 27

Warning: Undefined variable $aria_req in /www/wwwroot/lvshuige.com/wp-content/themes/JieStyle/comments.php on line 28

Warning: Undefined variable $aria_req in /www/wwwroot/lvshuige.com/wp-content/themes/JieStyle/comments.php on line 29

发表回复

您的邮箱地址不会被公开。 必填项已用 * 标注