07 2020 档案

SQL删除数据库某一字段内容重复的数据行
摘要：删除[field]字段内容重复的数据，[table]表名，[field]字段名 DELETE FROM [table] WHERE [id] NOT IN (SELECT MIN([id]) FROM [B_SensitiveWord] GROUP BY [field] Having Count(* 阅读全文
posted @ 2020-07-25 16:05 yuejin 阅读(2679) 评论(2) 推荐(1) 编辑

点击右上角即可分享
微信分享提示