Joyent

Manage SQLite databases

Creating a SQLite database

sqlite3 should be in your path.

To create a new database named newdb with a table newtable:

admin$ sqlite3 newdb
SQLite version 3.5.2
Enter ".help" for instructions
sqlite> create table newtable(id varchar(10), column smallint);

Removing a SQLite database

 
accelerators/kb/manage-sqlite.txt · Last modified: 2008/01/27 15:00 by alexbcoles
 
Recent changes RSS feed Creative Commons License Driven by DokuWiki