$ sqlite3
SQLite version 3.18.0 2017-02-11 14:59:58
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> create table t(id integer primary key, name text not null, date default current_date);
sqlite> .mode columns
sqlite> .header on
sqlite> pragma table_info(t);
cid name type notnull dflt_value pk
0 id integer 0 1
1 name text 1 0
2 date 0 current_da 0
pragma的输出有列和行,就像查询:
相关问题 更多 >
编程相关推荐