CREATE TABLE secondTable (
id int NOT NULL AUTO_INCREMENT,
word varchar(255) NULL,
PRIMARY KEY (id)
);
MSsql:
CREATE TABLE [secondTable] (
[id] int NOT NULL IDENTITY(1,1) ,
[word] varchar NULL ,
PRIMARY KEY ([id])
)
之后,您可以在secondTable中插入word的不同值。
INSERT INTO secondTable (word) SELECT distinct word FROM MyTable;
最后,您可以使用分组ID更新表格:
UPDATE MyTable
SET ID = (SELECT id from secondTable where MyTable.word = secondTable.word)