什么叫数据,什么叫做数据库?
数据:能够输入计算机并能被计算机程序识别和处理的信息集合
数据库:数据库是在数据库管理系统管理和控制之下,存放在存储介质上的数据集合
Sqlite数据库是轻量级的,源码c,代码大小250KB,2TB大小。
windows用法
1、在路径位置的地方输入sqlite3.exe可以直接进入命令行终端,很方便
当然也可以设置环境变量的方式,使它在哪个路径都可以找到并且运行sqlite3.exe
(1)此电脑->属性->高级系统设置
(2)第四步是把sqlite.exe所在的位置添加到环境变量里边了(命令行终端重启才能生效)
注意:可以检查环境变量是否设置成功:echo %PATH%
2、虽然文件在d盘,在c盘也可以操作了
3、创建数据库的过程
(1)创建数据库liybc.db,这是第一步还不算成功(
注意此处是还未进入数据库,在命令行终端下边进入,下边在linux系统下边的的截图正确,此处截图不正确
)(2).tables 查找数据库中的表名字
.schema [表名] 查看表数据结构
产看一下没有表的数据库文件,此时就生成了
(3)create table userinfo(username,password)
(4)查询一下这张表里边有数据没有 ,发现没有数据userinfo是表名
(5)插入数据
(6)再次查询
(7)更新表的数据
update userinfo set password=456 where username=’zmt111′;
如果没有条件限制语句where,则会把所有的密码都改为456(慎用)
)
Ubuntu下操作数据库
1、本地安装 sudo dpkg -i *.deb
2、在线安装sudo apt-get install sqlite3
安装成功的标志
命令行终端:sqlite3
两种命令(以”.”开头命令,系统命令;以”;”结尾的命令)
系统命令:.help
.quit
.exit
.schema 查看表的结构图
sql命令:(以”;”结尾)
create table stu(id integer,name char,score Integer);
表名:stu
字段名 字段类型:id Integer,name char,score Integer
(1)创建数据库或者打开数据库
(2)创建表
create table stu(id Integer,name char,score Integer );
(3)向表格中插入数据(对于字符型数据,类型char和string都可以,所以真值” ” ‘ ‘都可以)
sqlite> insert into stu values (1001,’zhangsan’,80);
sqlite> insert into stu values (1001, “zhangsan” ,80);
(4)查看表格中的数据
(5)部分插入
(6)部分查看
select * from stu;
select name,score from stu;
select name,score from stu where score=80 and or ;可以多个条件
(7)删除一条
delect * from stu;
delect name,score from stu;
delect name,score from stu where score=80 and or ;可以多个条件
(8)更新
update stu set name=’wangwu’ where id=1001;将1001的名字改成wangwu
update stu set name=’wangwu’,score = 88 where id=1001;
(9).databases 查看打开的数据库
.tables 查看当前数据库下有的表格
(9)插入一列
(10)删除一列(不支持)
.创建一张新的表
.删除原有的表
.将新的表名改成原有的表名
Sqlite3 API
(1)使用回调函数查询机制
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
int sqlite3_exec(
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
sqlite3* db,
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
const char *sql,
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
int (*callback)(void*,int,char**,char**),
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
void * arg,
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
char **errmsg
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
);
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
功能:执行一条sql语句
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
参数:db 数据库的句柄指针
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
sql 将要被执行sql语句
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
callback 回调函数, 只有在查询语句时,才给回调函数传参
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
arg 为callback 传参的
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
errmsg 错误信息的地址
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
返回值:成功 SQLITE_OK
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
出错 errcode 错误码
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
int (*callback)(void* arg ,int ncolumn ,char** f_value,char** f_name)
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
功能:得到查询结果,每找到一条记录自动执行一次回调函数
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
参数:arg 为回调函数传递参数使用的
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
ncolumn 记录中包含的字段的数目(也就是这个表中有多少列)
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
f_value 包含每个字段值的指针数组(这个指针数组就可以得到一个结果数值)
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
f_name 包含每个字段名称的指针数组(这个是是字段的名字) 返回值:成功 0,出错 非0
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
(2)不用回调函数的机制
上面介绍的 sqlite3_exec 是使用回调来执行 select 操作。还有一个方法可以直接查询而不需要回调。虽然回调显得代码整齐,但有时候你还是想要非回调的 select 查询。这可以通过 sqlite3_get_table 函数做到。
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
int sqlite3_get_table (sqlite3 *,
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
const char * sql,
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
char *** resultp,
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
int * nrow,
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
int * ncolumn,
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
char ** errmsg
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
);
第3个参数是查询结果,它依然一维数组(不要以为是二维数组,更不要以为是三维数组)。它内存布局是:第一行是字段名称,后面是紧接着是每个字段的值
简单例子
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
#include
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
#include
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
#include
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
#define DATABASE "stu.db"
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
int do_insert(sqlite3 * db)
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
{
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
int id;
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
char name[32]={};
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
int score;
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
char sql[128]={};
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
char *errmsg;
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
printf("Input id:");
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
scanf("%d",&id);
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
getchar();
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
printf("Input name:");
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
scanf("%s",name);
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
getchar();
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
printf("Input score:");
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
scanf("%d",&score);
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
getchar();
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
sprintf(sql,"insert into stu values(%d,'%s',%d);",id,name,score);
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
if(sqlite3_exec(db,sql,NULL,NULL,&errmsg)!=SQLITE_OK)
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
{
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
printf("%s\n",errmsg);
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
printf("xxxxx");
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
}
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
else
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
{
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
printf("Insert done.\n");
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
}
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
return 0;
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
}
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
int do_delete(sqlite3* db)
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
{
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
int id;
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
char sql[128] = {};
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
char* errmsg;
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
printf("Input id:");
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
scanf("%d", &id);
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
getchar();
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
sprintf(sql, "delete from stu where id =%d;", id);
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
if (sqlite3_exec(db, sql, NULL, NULL, &errmsg) != SQLITE_OK)
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
{
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
printf("%s\n", errmsg);
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
}
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
else
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
{
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
printf("Delete done.\n");
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
}
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
return 0;
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
}
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
int do_update(sqlite3* db)
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
{
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
int id;
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
char sql[128] = {};
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
int score;
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
char* errmsg;
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
printf("Input update id:");
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
scanf("%d", &id);
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
getchar();
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
printf("Update score");
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
scanf("%d",&score);
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
getchar();
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
sprintf(sql, "update stu set score = %d where id =%d;", score,id);
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
if (sqlite3_exec(db, sql, NULL, NULL, &errmsg) != SQLITE_OK)
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
{
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
printf("%s\n", errmsg);
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
}
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
else
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
{
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
printf("Update done.\n");
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
}
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
return 0;
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
}
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
int callback(void* para, int f_num, char** f_value, char** f_name)
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
{
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
printf(" 111111");
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
int i = 0;
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
for (i = 0; i < f_num; i++)
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
{
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
printf(" %s", f_value[i]);
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
}
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
putchar(10);
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
return 0;
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
}
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
int do_query(sqlite3* db)
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
{
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
char sql[128] = {};
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
char* errmsg;
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
char** resultp;
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
int nrow;
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
int ncloumn;
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
int index;
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
int i, j;
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
sprintf(sql, "select * from stu;");
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
if (sqlite3_get_table(db,sql,&resultp,&nrow,&ncloumn,&errmsg)!=SQLITE_OK)
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
{
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
printf("%s\n", errmsg);
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
}
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
index = 0;
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
printf("%d\t", nrow);
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
printf("%d\n", ncloumn);
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
for ( i = 0; i < nrow+1; i++)
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
{
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
for (j = 0; j < ncloumn; j++)
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
{
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
printf("%-11s", resultp[index++]);
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
}
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
putchar(10);
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
}
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
printf("Query done.\n");
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
return 0;
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
}
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
int main(int argc,const char *argv[])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
{
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
sqlite3 * db;
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
char *errmsg;
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
int cmd;
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
if(sqlite3_open(DATABASE,&db) !=SQLITE_OK)
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
{
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
printf("%s\n",sqlite3_errmsg(db));
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
return -1;
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
}
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
else
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
{
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
printf("Open DATABASE success.\n");
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
}
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
if(sqlite3_exec(db,"create table stu (id Integer , name char,score Integer);",NULL,NULL,&errmsg)!=SQLITE_OK)
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
{
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
printf("%s\n",errmsg);
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
}
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
else
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
{
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
printf("create table and open success.\n");
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
}
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
while(1)
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
{
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
printf("************************************\n");
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
printf("1:insert 2:delete 3:query 4:update 5:quit\n");
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
printf("************************************\n");
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
printf("Input cmd:");
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
scanf("%d",&cmd);
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
getchar();
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
switch(cmd)
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
{
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
case 1:
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
do_insert(db);
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
break;
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
case 2:
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
do_delete(db);
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
break;
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
case 3:
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
do_query(db);
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
break;
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
case 4:
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
do_update(db);
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
break;
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
case 5:
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
sqlite3_close(db);
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
exit(0);
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
default:
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
printf("err cmd");
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
}
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
}
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
return 0;
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
}
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
保存->编译->运行
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
gcc test.c -lsqlite3 -o test
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
./test
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
总结:
关于sqlite内datetime()和mysql的时间函数
sqlite3中 datetime()函数的使用
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
datetime('now') //这样会输出时间不正确
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
输出:2022-04-29 06:14:05
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
datetime('now','localtime') // 这种是正确的
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
输出:2022-04-29 14:14:09
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
看以看出差八个时区
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
如果在命令行终端查看打印出来那么:
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
select datetime('now','localtime')
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
mysql:思考mysql如何也输出这样的形式
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
select now();
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
2022-04-29 14:21:29
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
测试是否可以
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
select name from tb_user where mount ="beidou" and passwd ="bdic03";
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
输出:BDIC03
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
select name from tb_user where mount ="beidou" and passwd ="bdic03" and expire >= now();
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
Empty set(0.00sec);
![3、Sqlite3的简单应用](https://johngo-pic.oss-cn-beijing.aliyuncs.com/articles/20230809/101844dd08734c639f3f44be9a9facd6.png![])
Original: https://blog.csdn.net/m0_51512624/article/details/120885146
Author: 导航定位…
Title: 3、Sqlite3的简单应用
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/816256/
转载文章受原作者版权保护。转载请注明原作者出处!