一些以前用过的sql语句

发表于

# 将数据库字段中的特殊字符替换
UPDATE my_article_content SET content=REPLACE(content,'”',''),content=REPLACE(content,'“',''),content=REPLACE(content,' ',''),content=REPLACE(content,'…','')

# 查找重复记录
SELECT count(id) ids  FROM may_private_art  GROUP BY title  order by ids desc

# 删除重复数据
DELETE FROM `may_private_art` WHERE id NOT IN(SELECT * FROM(SELECT id FROM `may_private_art` GROUP BY title)AS b)

评论

发表回复

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