这里SQL语句中的"%s"将被你传入的参数代替. 你就可以只显示一部分的schema. 事实上".tables"的也是采用这种"LIKE"的方式,进行pattern查询的。 ".databases"命令将列出当前connection中所有的数据库。 一般至少包含2个,一个是 "main", the original database opened.另一个是"temp
The ".databases" command shows a list of all databases open in the current connection. There will always be at least 2. The first one is "main", the original database opened. The second is "temp", the database used for temporary tables. There may be additional databases listed for data...
.system CMD ARGS... Run CMD ARGS... in a system shell.tables ?TABLE? List names of tables matching LIKE pattern TABLE #列出匹配 LIKE 模式的表的名称。.testcase NAME Begin redirecting output to 'testcase-out.txt' #将输出重定向到testcase-out.txt的文件中.timeout MS Try...
Show the current values for various settings(显示各种设置) .tables ?PATTERN? List names of tables matching a LIKE pattern(查看数据库的表列表) .timeout MS Try opening locked tables for MS milliseconds(在 MS 时间内尝试打开被锁定的表) .width NUM NUM ... Set column widths for "column" mode(...
.databases List names and files of attached databases .dump ?TABLE? ... Dump the database in an SQL text format If TABLE specified, only dump tables matching LIKE pattern TABLE. .echo ON|OFF Turn command echo on or off .exit Exit this program ...
List names of tables matching LIKE pattern TABLE .testcase NAME Begin redirecting output to 'testcase-out.txt' .testctrl CMD ... Run various sqlite3_test_control() operations .timeout MS 尝试打开锁定的表 MS 毫秒 .timer on|off 开启或关闭SQL定时器 .trace ?OPTIONS? Output each SQL statement...
登录后复制.tables ?TABLE?List names of tables matching LIKE pattern TABLE 登录后复制.testcase NAMEBegin redirecting output to 'testcase-out.txt' 登录后复制.testctrl CMD ...Run various sqlite3_test_control() operations 登录后复制.timeout MS尝试打开锁定的表 MS 毫秒 ...
.tables table_name 显示表及视图,无参数显示所有表和视图。 .index table_name 显示表的索引,无参数显示所有表的索引。旧版本命令.indices .show 显示当前显示格式设置情况。 如:headers、mode、output、colseparator、rowseparator等。 .mode 显示当前使用的显示格式。
FILE?Send output toFILEor stdoutifFILEis omitted.quit Exitthisprogram.readFILERead inputfromFILEor command output.schema?PATTERN?Show theCREATEstatements matchingPATTERN.show Show the current valuesforvarious settings.tables?TABLE?List namesoftables matchingLIKEpatternTABLE... sqlite...
sqlite>.tables bak long//导入的是空表bak,long 数据的导出和导入: 导出:例如: $sqlite3 data.db sqlite> .mode list sqlite> .separator | sqlite> .outputtest_file_1 sqlite> select * fromlong; sqlite> .exit $ cattest_file_1 hhhhhh|2 hello|2 mall|5 suinvzi|8 meimei|5 $ 备注:每次导出...