mini2440上SQLite *** 作

概述(1)创建数据库文件test.db [root@mini2440 /]#cd /home/www #sqlite3 test.db SQLite version 3.7.7.1 2011-06-28 17:39:05 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> (2)创建表 sq

(1)创建数据库文件test.db
[root@mini2440 /]#cd /home/www
#sqlite3 test.db
sqlite version 3.7.7.1 2011-06-28 17:39:05
Enter ".help" for instructions
Enter sql statements terminated with a ";"
sqlite>

(2)创建表
sqlite> create @R_419_5991@ students(ID integer,name text,age integer);
sqlite> .@R_419_5991@s
students
sqlite>

(3)删除表
sqlite> drop @R_419_5991@ students
sqlite> .@R_419_5991@s
sqlite>

(4)查看表结构
sqlite> create @R_419_5991@ students(ID integer,age integer);
sqlite> .schema students
CREATE @R_419_5991@ students(ID integer,age integer);
sqlite>

(5)插入列
sqlite> alter @R_419_5991@ students add cul;
sqlite> alter @R_419_5991@ students add column sex text;
sqlite> .schema students
CREATE @R_419_5991@ students(ID integer,age integer,cul,sex text);
sqlite>

(6)插入表记录
sqlite> insert into students values(1,'aa',10,'m');
sqlite> insert into students values(2,'bb',11,1,'f');
sqlite> select * from students;
1|aa|10|0|m
2|bb|11|1|f
sqlite>

(7)重命名表
sqlite> alter @R_419_5991@ students rename to stu;
sqlite>

(8)删除某一列，这为列cul
sqlite> begin transaction;
sqlite> create temporary @R_419_5991@ stu_bak(ID integer,sex text);
sqlite> insert into stu_bak select ID,name,age,sex from stu;
sqlite> drop @R_419_5991@ stu;
sqlite> create @R_419_5991@ stu(ID integer,sex text);
sqlite> insert into stu select ID,sex from stu_bak;
sqlite> drop @R_419_5991@ stu_bak;
sqlite> select * from stu;
1|aa|10|m
2|bb|11|f
sqlite> commit;
sqlite>

(9)退出程序
sqlite> .quit
[root@mini2440 www]#

本篇文章来源于 linux公社网站(www.linuxidc.com) 原文链接：http://www.linuxidc.com/Linux/2012-02/54689.htm

总结

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

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