问题描述
我找不到可以打开从Mac上的终端制作的现有sqlite数据库文件的任何文档.我想向现有数据库添加一些其他行.我可能会搜索错误的东西,因此,任何指向我正确方向的东西都非常有用.
I can not find any documents where I can open existing sqlite database file that I made from the terminal on Mac. I want to add some additional rows to the existing database. I probably search for the wrong things, so anything that points me in the right direction is much appriciated.
推荐答案
如果要保留在终端中,可以使用命令sqlite3 [databasename]
打开sqlite3数据库.在这里,您可以使用SQL命令选择行或插入新行.如果您喜欢GUI,则有很多选择,包括免费的Firefox插件 sqlite-manager .
If you want to remain in the Terminal, you can open a sqlite3 database using the command sqlite3 [databasename]
. From here, you can select rows or insert new ones using SQL commands. If you prefer a GUI, there are many to choose from, including the free Firefox plugin, sqlite-manager.
这篇关于从终端Mac编辑sqlite文件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!