jeudi 18 février 2016

Prepared Inserts multiple rows in single query in Sqlite IOS

I am currently using this type of query for insert multiple rows of values in one single query:

INSERT INTO 'tablename'
      SELECT 'data1' AS 'column1', 'data2' AS 'column2'
 UNION ALL SELECT 'data1', 'data2'
 UNION ALL SELECT 'data1', 'data2'
 UNION ALL SELECT 'data1', 'data2'

Its any other way to using prepared statement insert multiple rows in single query? its like

insert into table (fielda, fieldb, ... ) values (?,?...), (?,?...)....

If is possible how to implement this in ios ?

Aucun commentaire:

Enregistrer un commentaire