Sqlite3

http://www.tutorialspoint.com/sqlite/

• select 查询结果 format:

.header on

.mode column

.timer on

• show the table creating syntax

sqlite> SELECT sql FROM sqlite_master WHERE type = 'table' AND tbl_name = 'COMPANY';

• show all tables created in one DB schema:

sqlite> SELECT tbl_name FROM sqlite_master WHERE type = 'table';

 

 

Ubuntu: 

sudo apt-get install libsqlite3-dev

gcc -o version version.c -lsqlite3