[sqlite/SQL] 문법 몇가지

.open database_name;

.table

.

CREATE TABLE table_name ( no integer primary key autoincrement, name text );

INSERT INTO table_name ( name ) values ( 'name_1' ), ( 'name_2' ), ( 'name_3' );

INSERT INTO table_name ( no, name ) (SELECT exp1, exp2 FROM some_table WHERE condition);