sqlite3使用点滴

最新推荐文章于 2024-07-06 20:05:07 发布

jackywu1010

最新推荐文章于 2024-07-06 20:05:07 发布

阅读量604

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/jackywu1010/article/details/8488664

本文介绍了SQLite数据库的常见错误码，包括权限问题、内存不足、磁盘I/O错误等，并提到了SQLite的事务处理（BEGIN和COMMIT）以及如何复位主键的AUTO_INCREMENT属性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

exec错误码
#define SQLITE_OK           0   /* Successful result */
#define SQLITE_ERROR        1   /* SQL error or missing database */
#define SQLITE_INTERNAL     2   /* An internal logic error in SQLite */
#define SQLITE_PERM         3   /* Access permission denied */
#define SQLITE_ABORT        4   /* Callback routine requested an abort */
#define SQLITE_BUSY         5   /* The database file is locked */
#define SQLITE_LOCKED       6   /* A table in the database is locked */
#define SQLITE_NOMEM        7   /* A malloc() failed */
#define SQLITE_READONLY     8   /* Attempt to write a readonly database */
#define SQLITE_INTERRUPT    9   /* Operation terminated by sqlite_interrupt() */
#define SQLITE_IOERR       10   /* Some kind of disk I/O error occurred */
#define SQLITE_CORRUPT     11   /* The database disk image is malformed */
#define SQLITE_NOTFOUND    12   /* (Internal Only) Table or record not found */
#define SQLITE_FULL        13   /* Insertion failed because database is full */
#define SQLITE_CANTOPEN    14   /* Unable to open the database file */
#define SQLITE_PROTOCOL    15   /* Database lock protocol error */
#define SQLITE_EMPTY       16   /* (Internal Only) Database table is empty */
#define SQLITE_SCHEMA      17   /* The database schema changed */
#define SQLITE_TOOBIG      18   /* Too much data for one row of a table */
#define SQLITE_CONSTRAINT 19   /* Abort due to contraint violation */
#define SQLITE_MISMATCH    20   /* Data type mismatch */
#define SQLITE_MISUSE      21   /* Library used incorrectly */
#define SQLITE_NOLFS       22   /* Uses OS features not supported on host */
#define SQLITE_AUTH        23   /* Authorization denied */
#define SQLITE_ROW         100 /* sqlite_step() has another row ready */
#define SQLITE_DONE        101 /* sqlite_step() has finished executing */

SQLite优化方法
详细出处参考：http://www.jb51.net/article/15836.htm

rc = sqlite3_exec(db, "BEGIN;", 0, 0, &zErrMsg);

//执行SQL语句

rc = sqlite3_exec(db, "COMMIT;", 0, 0, &zErrMsg);

SQLITE AUTO_INCREMENT 复位：

DELETE FROM sqlite_sequence WHERE name = 'your_table_name'

ALTERTABLE your_table_name AUTO_INCREMENT = 1

主键自动增长，只需

primary key autoincrement