SQLite 常用语句 sql语句

概述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,mean

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

以上是内存溢出为你收集整理的SQLite 常用语句 sql语句全部内容，希望文章能够帮你解决SQLite 常用语句 sql语句所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。