db | James Cheng

Showing all posts tagged #db:

SQlite

Posted on June 24th, 2014

[Import]

http://www.sqlite.org/cvstrac/wiki?p=ImportingFiles
sqlite> create table test (id integer, datatype_id integer, level integer, meaning text);
sqlite> .separator ","
sqlite> .import no_yes.csv test
commands: http://www.sqlite.org/cli.html

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