@开局警示:建议一步一步测试或重新建表测试,避免操作不当误删
DELETE
FROM
users
WHERE
id NOT IN ( SELECT temp.min_id FROM (
SELECT MIN(id) min_id FROM t_cement_concrete_info GROUP BY produce_time
) AS temp);
请编写一个SQL语句,清除表中垃圾数据
1.首先查看重复数据
SELECT
id,
user_name,
user_code,
FROM
users
GROUP BY
user_name,
user_code
注意:MySQL5.7以上默认开启了only_full_group_by模式,查询了非分组字段会报错
windows打开my.ini直接删掉only_full_group_by这一项即可
mac在my.cnf文件中下列代码到mysqld配置中
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
重启mysql服务就会生效
2.选择最小的id
SELECT
MI