Geek Answers Handbook

Open a database and view tables in sqlite3?

The first user, sqlite3, starts windows and starts to work with difficulty. I have a database in the same folder as my sqlite3.exe application that I want to import into sqlite3 so that I can view its tables.

The database is called slash09.db. I tried .read slash09.db and something happened, but it returns a bunch of garbage characters. What teams should try to open / import and view its tables?

Also, if you know a good online link to learn sqlite3, I would like to read it. For some reason google didn't find much for me.

+7
source share
3 answers

In case any tool works, Firefox has a really good plugin called SQLite Manager , which is very useful for checking queries and modifying arbitrary sqlite dbs (not particularly related to firefox).

+4
source

.read FILENAME will be Execute SQL in FILENAME .

If you want to open the slash09.db sqlite3 database, just run:

 sqlite3 slash09.db

For more information on the various commands in the sqlite3 console, try .help . For example, you can run .tables to list the tables in your database.

+13
source

sqlitebrowser is a good gui, I use both cl and sqlitebrowser.

+1
source

More articles:


All Articles