26th December

SQLite

sql engine suitable for simple application(iphone)

Mac OSX terminal>sqlite3
For GUI sqlite browser, use firefox extension called SQLite Manager by M.Kant & T.Tripathy

Useful command

SELECT * FROM shop WHERE shop_name NOT LIKE 'seven%'
This will return rows that don't have 'seven' as initial text in shop_name column.

SELECT DITINCT shop_name FROM shop
This will return rows that have unique values in shop_name column.