SQLite3 sqlite3_exec返回值

int sqlite3_exec(
   sqlite3* ppDb,                             /* An open database */
   const char *sql,                           /* SQL to be evaluated */
   int (*callback)(void*,int,char**,char**),  /* Callback function */
   void *,                                    /* 1st argument to callback */
   char **errmsg                              /* Error msg written here */
);//函数原型

1、操作成功

SQLITE_OK = 0; 返回成功

2、操作失败

SQLITE_ERROR = 1;         SQL错误或错误的数据库

SQLITE_INTERNAL = 2;         An internal logic error in SQLite

SQLITE_PERM = 3;         拒绝访问

SQLITE_ABORT = 4;         回调函数请求中断

SQLITE_BUSY = 5;         数据库文件被锁

SQLITE_LOCKED = 6;         数据库中的一个表被锁

SQLITE_NOMEM = 7;         内存分配失败

SQLITE_READONLY = 8;         试图对一个只读数据库进行写操作

SQLITE_INTERRUPT = 9;         由sqlite_interrupt()结束操作

SQLITE_IOERR = 10;         磁盘I/O发生错误

SQLITE_CORRUPT = 11;         数据库磁盘镜像畸形

SQLITE_NOTFOUND = 12;         (Internal Only)表或记录不存在

SQLITE_FULL = 13;         数据库满插入失败

SQLITE_CANTOPEN = 14;         不能打开数据库文件

SQLITE_PROTOCOL = 15;         数据库锁定协议错误

SQLITE_EMPTY = 16;         (Internal Only)数据库表为空

SQLITE_SCHEMA = 17;         数据库模式改变

SQLITE_TOOBIG = 18;         对一个表数据行过多

SQLITE_CONSTRAINT = 19;         由于约束冲突而中止(unique)

SQLITE_MISMATCH = 20;         数据类型不匹配

SQLITE_MISUSE = 21;         数据库错误使用

SQLITE_NOLFS = 22;         使用主机操作系统不支持的特性

SQLITE_AUTH = 23;         非法授权

SQLITE_FORMAT = 24;         辅助数据库格式错误

SQLITE_RANGE = 25;         2nd parameter to sqlite_bind out of range

SQLITE_NOTADB = 26;         打开的不是一个数据库文件

SQLITE_ROW = 100;         sqlite_step() has another row ready

SQLITE_DONE = 101;         sqlite_step() has finished executing