CREATE TABLE `knowledge_synonym` (
`id` INT ( 11 ) NOT NULL AUTO_INCREMENT,
`kbId` INT ( 11 ) NOT NULL,
`word` VARCHAR ( 255 ) CHARACTER
SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`wordSynonym` VARCHAR ( 10000 ) CHARACTER
SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`synonymNum` INT ( 11 ) DEFAULT NULL,
`createTime` VARCHAR ( 255 ) CHARACTER
SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
`updateTime` VARCHAR ( 255 ) CHARACTER
SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
PRIMARY KEY ( `id` ),
KEY `index_one` ( `kbId` )
) ENGINE = INNODB AUTO_INCREMENT = 189 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ;
洗掉word欄位重復的資料，保留其中id最小的一條
delete from knowledge_synonym where id not in
(
select id from (
select min(id) id from knowledge_synonym t group by t.word
) z
)
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/249612.html
標籤：MySQL
上一篇：如何查詢圖一a列中的值在b列的出現次數，并最侄訓得圖二的結果集
下一篇：office