问题描述
如何开始使用sqlite3数据库?
例如，有 http://openports.se/databases/sqlports ，其中包含有关OpenBSD端口；我已将其安装在OpenBSD 5.2上，并且根据/var/db/pkg/sqlports-2.3p0/+CONTENTS创建的唯一文件是/usr/local中的share/sqlports.
For example, there's http://openports.se/databases/sqlports that contains various info about OpenBSD ports; I've installed it on OpenBSD 5.2, and the only file it created, as per /var/db/pkg/sqlports-2.3p0/+CONTENTS, is share/sqlports in /usr/local.
% file /usr/local/share/sqlports
/usr/local/share/sqlports: SQLite 3.x database
我如何知道它具有哪些表以及每个表具有哪些字段?
How do I know which tables it has, and what fields does each table has?
推荐答案
cnst，您的答案是正确的.您也可以使用.命令.例如列出您输入.databases的数据库并获取表.tables
cnst your answer is right. You can also use the . commands .for example to list the databases you enter .databases and to get the tables .tables
尝试.help以获得更多可能的命令.
Try .help for more possible commands.
对于OpenBSD pkg信息，您可以在文件系统友好格式下的目录下找到它们./var/db/pkg/
As for OpenBSD pkg info you can find them in a filesystem friendly format, in directories under/var/db/pkg/
这篇关于列出OpenBSD数据库/sqlports sqlite3数据库的表和字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！