sqlite3
hushui
Coding Since 1998
展开
-
sqlite/Temp table/TRIGGER
The schema for TEMPORARY tables is not stored in the "sqlite_master" table since TEMPORARY tables are not visible to applications other than the application that created the table. The schema for TEMPORARY tables is stored in another special table named "s原创 2021-06-16 09:45:35 · 179 阅读 · 0 评论 -
sqldiff /sqlite-tools-win32-x86-3340000
### sqldiff /sqlite-tools-win32-x86-3340000 Example PS C:\work\> ..\..\sqlite-tools-win32-x86-3340000\sqldiff.exe .\0clear\recordings.db .\1-boot-nostart\recordings.db INSERT INTO Bookings(bookingId,segmentId,type) VALUES(31,5,1); INSERT I...原创 2021-01-08 15:32:29 · 461 阅读 · 0 评论 -
sqlite3.7.17 basic command line on RHEL/Centos7
[lake@local ~]$ sqlite3 SQLite version 3.7.17 2013-05-20 00:56:22 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> ^C sqlite> quit ...> exitl ...> ex...原创 2019-01-14 17:44:32 · 374 阅读 · 0 评论 -
sqlite3.7.17 programming C callback function through sqlite3_exec
[lake@lake-aliyun-sh-china sqlite3]$ cat sqlite3-search.c #include <stdio.h> #include <stdlib.h> #include <unistd.h> #include <sqlite3.h> #define DB_FILE_NAME "stu.db" /**...原创 2019-01-15 21:25:33 · 189 阅读 · 0 评论