Sqlite3数据库基本运用

sqlite3的基本命令

在Linux系统中，输入sqlite3，进入sqlite3界面
–退出表
.exit
除去退出以外，其他命令都需要以分号结束
创建表
create table student (id integer, name text, sex text);
create table if not exists student (id integer, name text, sex text);

– 查看表
.tables

– 查看表结构
.schema student

– 插入数据
insert into student (id, name, sex) values (1, “aaaa”, “male”);
insert into student (id, sex) values (2, “female”);
insert into student values(3, “cccc”, “male”);
insert into student values (4, “dddd”, “f”), (5, “eeeee”, “f”), (6, “fff”, “m”);

– 查找数据
select * from student;
select * from student where id = 1;
select name from student where id = 2;
select * from student where id > 3 and id < 6;
select name from student where id between 3 and 6;

– 修改数据
update student set name = “bbbb” where id = 2;

– 删除数据
delete from student where name = “aaaa”;

– 删除表
drop table student;

一.编程中实现插入创建表和插入数据

sqlite3_exec()函数，里面有五个形参（数据库句柄，执行的命令，回调函数，传参，错误信息）

二…插入数据并且查看表（一种通过调用函数来挨个打印表内容实现，一种通过sqlite3_get_table函数来实现）