개발

"INSERT OR IGNORE" (="INSERT ON CONFLICT IGNORE")

> 초기값 셋팅에 활용

"INSERT OR UPDATE"
> 중복시 값 변경에 활용

- INSERT OR IGNORE

- INSERT OR UPDATE

http://hangaebal.blogspot.kr/2014/06/web-sql-insert-or.html

insert multiple rows at a time in an SQLite database

MySQL example:
INSERT INTO 'tablename' ('column1', 'column2') VALUES
  ('data1', 'data2'),
  ('data3', 'data4'),
  ('data5', 'data6'),
  ('data7', 'data8');

This can be recast into SQLite as:
INSERT INTO 'tablename'
      SELECT 'data1' AS 'column1', 'data2' AS 'column2'
UNION SELECT 'data3', 'data4'
UNION SELECT 'data5', 'data6'
UNION SELECT 'data7', 'data8'


http://hangaebal.blogspot.kr/2014/06/web-sql.html

http://stackoverflow.com/questions/1609637/is-it-possible-to-insert-multiple-rows-at-a-time-in-an-sqlite-database