UPDATE news SET title = CONCAT(title, id);我知道这个恐怕不是你想要的,不过你的原帖实在是没说清楚你想要什么。 ———————————————————————————————— 基于CSDN论坛提供的插件扩展功能,自己做了个签名档工具,分享给大家,欢迎技术交流 :)
如下是删除相同的ID为大的,保留ID为小的一条,更新一样的,更改相应的语句就行了DELETE FROM news WHERE title IN (SELECT title FROM news GROUP BY title HAVING COUNT(title)>1) AND title NOT IN (SELECT MIN(id) FROM news GROUP BY news HAVING COUNT(title)>1)
可能有性能问题 UPDATE news b SET b.title=CONCAT(b.title,',',b.id) WHERE b.title IN (SELECT * FROM (SELECT a.title FROM news a GROUP BY a.title HAVING COUNT(*)>1) c)
————————————————————————————————
基于CSDN论坛提供的插件扩展功能,自己做了个签名档工具,分享给大家,欢迎技术交流 :)
select DISTINCT(title),id,text from.....
UPDATE news b
SET b.title=CONCAT(b.title,',',b.id)
WHERE b.title IN (SELECT * FROM (SELECT a.title FROM news a GROUP BY a.title HAVING COUNT(*)>1) c)