1、创建表

create table Words_new

(rowid INTEGER PRIMARY KEY AUTOINCREMENT,word text NOT NULL,meanings text NOT NULL,pronounce text); 2、插入数据 insert into Words_new (word,meanings,pronounce) select word,pronounce from Words; 3、update 多表查询 修改 update Words set meanings=(select meanings from Words_one where Words.[word]=Words_one.[word]),pronounce=(select pronounce from Words_one where Words.[word]=Words_one.[word]) Where Words.[word]=(select word from Words_one where Words.[word]=Words_one.[word]);