学习 Go (Part 4: sqlite)

[nonocast]

sqlite3

• 十分钟掌握SQLite操作 - 技术小黑屋
• SQLite In 5 Minutes Or Less

~ sqlite3 hello.db
SQLite version 3.37.0 2021-12-09 01:34:53
Enter ".help" for usage hints.
sqlite> .tables
sqlite> CREATE TABLE IF NOT EXISTS `users` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `name` TEXT NOT NULL, `age` INTEGER DEFAULT 0);
sqlite> 
sqlite> .tables
users
sqlite> .schema users
CREATE TABLE `users` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, `name` TEXT NOT NULL, `age` INTEGER DEFAULT 0);
sqlite> 
sqlite> .header on
sqlite> .mode column
sqlite> pragma table_info('users');
cid  name  type     notnull  dflt_value  pk
---  ----  -------  -------  ----------  --
0    id    INTEGER  0                    1 
1    name  TEXT     1                    0 
2    age   INTEGER  0        0           0 
sqlite> 
sqlite> 
sqlite> insert into users (name, age) values ('nonocast', 66);
sqlite> insert into users (name, age) values ('minnie', 11);
sqlite> 
sqlite> select * from users;
id  name      age
--  --------  ---
1   nonocast  66 
2   minnie    11 
sqlite> 

program