2005/5/10

     
 

SQLite3 util

artefaktur

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 http://www.sqlite.org/cvstrac/wiki?p=SqliteTools.