从终端Mac编辑sqlite文件 [英] Edit sqlite file from terminal Mac

问题描述

我找不到可以打开从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文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！