进入交互模式
1 | sqlite3 event.db |
查看所有表
1 | .tables |
1 | select name from sqlite_master where type='table'; |
查看表结构
1 | .schema event_statistic |
查看表数据
1 | select * from event_statistic limit 10; |
退出交互模式
1 | .exit |
更新于：
1 | sqlite3 event.db |
1 | .tables |
1 | select name from sqlite_master where type='table'; |
1 | .schema event_statistic |
1 | select * from event_statistic limit 10; |
1 | .exit |