I Leistungen I Werdegang I Downloads I acdk I Kontakt I Datenschutzerklärung I

SQLite3 is the orignal command line utility from the SQLite distribution.

Content of this chapter:    SQLite3 usage      Start sqlite3    Other (GUI) Tools

 SQLite3 usage

SQLite3 is a command line utility to execute SQL command and modify, import, export a SQLite3 database.

 Start sqlite3

Start the sqlite3 tool with:
sqlite3 dbfile.db
Now you can either enter an internal command (type .help to receive a list of internal commands) or enter a SQL statement.

 Other (GUI) Tools

There are countless free and commercial graphical tools for most platforms supported by ACDK to manipulate SQLite3 databases.

Please refer to  http://www.sqlite.org/cvstrac/wiki?p=SqliteTools.