SQLite的一些命令语句
发布时间:2020-12-13 00:05:21 所属栏目:百科 来源:网络整理
导读:首先我自己建立一个sqlite3的数据库: 使用文件phone.sql CREATE TABLE IF NOT EXISTS PHONETABLE (id integer primary key,name text,phone_number integer);INSERT into PHONETABLE (name,phone_number) values('Jone','15901110265');INSERT into PHONETA
首先我自己建立一个sqlite3的数据库: 使用文件phone.sql CREATE TABLE IF NOT EXISTS PHONETABLE (id integer primary key,name text,phone_number integer); INSERT into PHONETABLE (name,phone_number) values('Jone','15901110265'); INSERT into PHONETABLE (name,phone_number) values('Jack','13811907568'); INSERT into PHONETABLE (name,phone_number) values('Jackson','15901110861'); INSERT into PHONETABLE (name,phone_number) values('Mike','13259647865'); INSERT into PHONETABLE (name,phone_number) values('Steven','13756231023'); INSERT into PHONETABLE (name,phone_number) values('Yao','15880156324');建立数据库:sqlite3 phone.db < phone.sql 创建表格:CREATE TABLE IF NOT EXISTS PHONETABLE (id integer primary key,phone_number integer); 插入数据:INSERT into PHONETABLE (name,'15901110265'); 删除数据:DELETE FROM phonetable where name='Jack' 修改数据:UPDATE phonetable set name='Jack' where name='Jone' 查询数据:查询全部: SELECT * FROM phonetable; 条件查询: SELECT *FROM phonetable where name='Jack'; SELECT *FROM phonetable where name LIKE 'J%'; (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |