mysql如何查询重复的数据,去重
摘要:
SELECT column1, column2, COUNT(*) FROM table_name GROUP BY column1, column2 HAVING COUNT(*) > 1; -- 假设id是主键或唯一标识DELETE t1 FROM pv_meter_daily_power t1 阅读全文
posted @ 2025-08-15 14:24 yebinghuai-qq-com 阅读(19) 评论(0) 推荐(0)
浙公网安备 33010602011771号