sqlite3使用点滴

sqlite3使用点滴,第1张

概述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

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;",&zErrMsg);

//执行SQL语句

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

sqlITE auto_INCREMENT 复位:

DELETE FROM sqlite_sequence WHERE name = 'your_table_name'

ALTERtable your_table_name auto_INCREMENT = 1

主键自动增长,只需

primary key autoincrement

总结

以上是内存溢出为你收集整理的sqlite3使用点滴全部内容,希望文章能够帮你解决sqlite3使用点滴所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错,欢迎将内存溢出网站推荐给程序员好友。

欢迎分享,转载请注明来源:内存溢出

原文地址: http://outofmemory.cn/sjk/1174684.html

(0)
打赏 微信扫一扫 微信扫一扫 支付宝扫一扫 支付宝扫一扫
上一篇 2022-06-02
下一篇 2022-06-02

发表评论

登录后才能评论

评论列表(0条)

保存