Sqlite数据库操作的sql操作语句
用sqlite3建立数据库的方法很简单,只要在shell下键入(以下$符号为shell提示号,请勿键入): $ sqlite3 foo.db
SQLite version 3.1.3Enter ".help" for instructionssqlite>
create table film(title,length,year,starring); 这个create table指令的语法为: create table table_name(field1,field2,field3,...);
create index film_title_index on film(title); create index index_name on table_name(field_to_be_indexed);
insert into table_name values(da insert into film values ('Silence of the Lambs,The',118,1991,'Jodie Foster');insert into film values ('Contact',153,1997,'Jodie Foster');insert into film values ('Crouching Tiger,Hidden Dragon',120,2000,'Yun-Fat Chow');insert into film values ('Hours,114,2002,'Nicole Kidman'); 如果只填充部分字段(比如id设置为自动递增字段,无需填充的时候,使用如下sql语句('pic_name','date_time','reason')为字段名字:
select columns from table_name where expr select * from film; select * from film limit 10; select * from film order by year limit 10; select * from film order by year desc limit 10; select title,year from film order by year desc limit 10; select * from film where starring='Jodie Foster'; select * from film where starring like 'Jodie%'; select title,year from film where starring like 'Jodie%' and year >= 1985 order by year desc limit 10; select count(*) from film; select count(*) from film where year >= 1985;
例如有一笔资料的名字打错了: update film set starring='Jodie Foster' where starring='Jodee Foster'; delete from film where year < 1970;
sqlite3 film.db "select * from film;" sqlite3 -html film.db "select * from film;" sqlite3 film.db ".dump" > output.sql sqlite3 film.db < output.sql begin; commit; (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |