SQLite 常用语句 sql语句

发布时间：2020-12-12 20:02:17 所属栏目：百科来源：网络整理

导读：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 多

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]);

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!