sqlite3 简单使用

最新推荐文章于 2024-06-01 12:27:46 发布

ttt2

最新推荐文章于 2024-06-01 12:27:46 发布

阅读量4.7k

点赞数

分类专栏： asp 文章标签： sqlite 数据库 insert sql table shell

本文链接：https://blog.csdn.net/ttt2/article/details/6123912

版权

本文介绍了SQLite3的简单使用，包括如何通过shell创建数据库、建立资料表、插入数据、查询资料、更改或删除资料。此外，还提到了SQLite3的特性，如支持大部分SQL指令，一个档案即为数据库，以及其在OS X系统中的应用。

摘要由CSDN通过智能技术生成

H:/Ruby192/bin>sqlite3 a.db
SQLite version 3.7.4
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .database;
Error: unknown command or invalid arguments: "database;". Enter ".help" for he
p
sqlite> .database
seq name file

--- --------------- ---------------------------------------------------------

0 main H:/Ruby192/bin/a.db

sqlite> .table
a
sqlite> insert into a(1)
...> ;
Error: near "1": syntax error
sqlite> select * from a;
sqlite> selet * from a
...> ;
Error: near "selet": syntax error
sqlite> select * from a;
sqlite> insert a (id) values(1);
Error: near "a": syntax error
sqlite> insert a (id) values(1);
Error: near "a": syntax error
sqlite> insert into a (id) values(1);
sqlite> select * from a;
1
sqlite> insert into a (id) values(12);
sqlite> insert into a (id) values(13);
sqlite> insert into a (id) values(15);
sqlite> select * from a;
1
12
13
15
sqlite> alter table a (add column b varchar(10));
Error: near "(": syntax error
sqlite> alter table a add column b varchar(10);
sqlite> insert into a (id) values(16,'a');
Error: 2 values for 1 columns
sqlite> insert into a (id,b) values(16,'a');
sqlite> select * from a;
1|
12|
13|
15|
16|a
sqlite> select top 1 * from a ;
Error: near "1": syntax error
sqlite> select * from a limit 1;
1|
sqlite> select * from a order by id desc limit 1;
16|a
sqlite> select * from a order by id desc limit 1 to 2;
Error: near "to": syntax error
sqlite> select * from a order by id desc limit 10;
16|a
15|
13|
12|
1|
sqlite>