sqlite3C语言api

apt-get install sqlite3

sqlite3  //进入sqlite3,内容保存至内存，退出后内容会丢失
sqlite3 <表名> //保存到文件中，例sqlite3 student 
.exit     //退出sqlite3，‘.'不能少

#以学生表为例
create table student(id integer,name text,age integer);

.schema

insert into student(id,name,age) values(1,"aa",11);

insert into student(id,name,age) values(1,"aa",11),values(2,"bb",12);//部分sqlite3可能不支持多条插入

select * from student;

update student set age = 25 where id  = 3;

delete from student where id = 1;

drop table student;

找不到sqlite3.h时执行 apt-get install libsqlite3-dev 安装

sqlite3 *ppdb;
int ret = sqlite3_open("student.db",&ppdb);
if(ret != SQLITE3_OK)
{
    printf("sqlite3 open error:%s\n",sqlite3_errmsg(ppdb));
    exit(1);
}

char sql[128] = {0};
spirntf(sql,"create table if not exists student(id integer,name text,age integer);");

ret = sqlite3_exec(ppdb,sql,NULL,NULL,NULL);
if(ret != SQLITE_OK)
{
　　printf("sqlite3_execl err:%s\n",sqlite3_errmsg(ppdb));
　　exit(1);
}

scanf("%d%s%d,$id,name,&age);
sprintf(sql,"insert into student values(%d,'%d',%d);
ret = sqlite3_exec(ppdb,sql,NULL,NULL);