SQL

Posted on June 24th, 2014

[SELECT]

[DELETE]

Delete from : http://stackoverflow.com/questions/5132691/combing-delete-and-like-in-a-sqlite-statement
Delete: http://technet.microsoft.com/zh-tw/library/ms189245(v=sql.105).aspx
Delete table : http://www.tutorialspoint.com/sqlite/sqlite_truncate_table.htm

[INSERT]

insert into table_name select whatever...
http://stackoverflow.com/questions/7387338/sqlite-insert-select-query-results-into-existing-table
insert , values
http://stackoverflow.com/questions/3620828/sqlite-select-where-empty

#db