SQLite

From aoxoaWiki
Jump to: navigation, search

SQLite is a lightweight file-based database.

The SQLite software is included in Mac OSX.


Topics

SQLite may already be installed. See if the command sqlite3 works....

To install SQLITE on a Mac:

SQLite Downloads page


To create a new SQLite database:

  cd <directory>
  sqlite3 <dbname>.db
  create table zyz ( column1 integer );
  .exit


To list the structure of a table:

  .schema table_name
  or
  .headers on
  PRAGMA table_info(table_name);

.schema show sql create statement; PRAGMA lists column details

Online Resources


Back to Main Page