SQLite3 Cheatsheet

Tools

1. MesaSQLite for MacOSX.

SQL

1. Getting the current time

MySQL = Now();

SQLite3 = CURRENT_TIMESTAMP;

insert into jobstemp(full_address, datecreated, dateupdated)
VALUES("9 Bishop Street", CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);

2. Getting the local current time

SELECT datetime(dateupdated, 'localtime')

3. Trim

SELECT trim(name) FROM table

4. Vacuum

rupert:Desktop rupert$ sqlite3 photos-2.0.0.db 
SQLite version 3.6.12
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> vacuum;
sqlite> .quit;

5. Quit

rupert:Desktop rupert$ sqlite3 photos-2.0.0.db 
SQLite version 3.6.12
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .quit;