Show status information about the database(显示有关数据库的状态信息) .dump ?TABLE? ... Render all database content as SQL(将所有数据库内容呈现为SQL) .echo on|off Turn command echo on or off(打开或关闭命令回显) .eqp on|off|full|... Enable or disable automatic EXPLAIN QUERY PLAN(启用或...
The sqlite3 program is able to show the results of a query in eight different formats: "csv", "column", "html", "insert", "line", "list", "tabs", and "tcl". You can use the ".mode" dot command to switch between these output formats. The default output mode is "list". In l...
Show status information about the database .dump ?OBJECTS?以 SQL 文本格式转储数据库 .echo on|off开启或关闭 echo 命令 .eqp on|off|full|...Enable or disable automaticEXPLAIN QUERY PLAN .excelDisplay the output of next command in spreadsheet .exit ?CODE?以CODE码退出SQLite提示符 .expertEXPERIMENT...
Show the CREATE statements(显示 CREATE 语句) .separator STRING Change separator used by output mode and .import .show Show the current values for various settings(显示各种设置) .tables ?PATTERN? List names of tables matching a LIKE pattern(查看数据库的表列表) .timeout MS Try opening locked ta...
.quit <4>显⽰当前打开的数据库⽂的位置 .database 在当前的数据库⽂件中创建⼀张新表（语句） [注：以;结尾,<>中是我们可变的内容]create table <table_name>(表头信息1,表头信息2，表头信息3...);例如：create table people(NAME,SEX,AGE);<5>显⽰数据库中所有的表名 sqlite>.tables <6>...
相当于mysql的show tables命令 代码语言:javascript 复制 sqlite> .tables 退出SQLite 退出SQLite命令为.quit或.exit 代码语言:javascript 复制 sqlite> .quit 代码语言:javascript 复制 sqlite> .exit 备份与恢复 SQLite备份数据库的命令为.backup或者.save,其作用是将当前数据库备份到指定的文件中 代码语言:javascript...
.echo ON|OFF Turn command echo on or off .exit Exit this program .explain ?ON|OFF? Turn output mode suitable for EXPLAIN on or off. With no args, it turns EXPLAIN on. .header(s) ON|OFF Turn display of headers on or off .help Show this message ...
参考官方命令参考:Command Line Shell For SQLite 常用命令: # 创建/进入 一个数据库 $ sqlite3 DB_Test # 显示当前数据库中的所有表 sqlite> .tables # 显示所有schemas sqlite> .schema # 显示某个表的schema sqlite> .schema tb_Users sqlite> .schema tb_* # 显示当前的客户端偏好设定 sqllite> .sho...
If TABLE specified,only dump tables matching LIKE pattern TABLE..echo ON|OFF Turn command echo on or off.exit Exitthisprogram.explain?ON|OFF?Turn output mode suitableforEXPLAIN on or off.With no args,it turns EXPLAIN on..header(s)ON|OFF Turn display of headers on or off.help Showthismes...
十四.参数化的SQL语句sqlite可以在shell/dos command底下直接执行命令:对数据库进 40、行SQL操作:sqlite3数据库 SQL语句 或 .命令;输出 HTML 表格:sqlite3 -html film.db select * from film;将数据库导出来:sqlite3 film.db .dump output.sql利用输出的资料,建立一个一模一样的数据库(加上以上指令,就是...