本文介绍了列出OpenBSD数据库/sqlports sqlite3数据库的表和字段的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

如何开始使用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数据库的表和字段的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

10-11 10:52