sql - ruby on rails: multiple insertion SQLite3::SQLException: near ",": syntax error: -

i need multiple insertion in database.it shows me error time

single insertion works perfect:

conn = activerecord::base.connection  irb(main):271:0> inserts.push'(1,2,3,4,5,6)' => ["(1,2,3,4,5,6)"]  sql="insert signals_rmas (groupsnorm_id, arraydb_id, probeset_id,signal,updated_at,created_at) values #{inserts.join(", ")}"  irb(main):276:0> conn.execute sql    (32.3ms)  insert signals_rmas (groupsnorm_id, arraydb_id, probeset_id,signal,updated_at,created_at) values (1,2,3,4,5,6) => [] 

multiple insertions not work @ all:

irb(main):272:0> inserts.push'(7,8,9,10,11,12)' => ["(1,2,3,4,5,6)", "(7,8,9,10,11,12)"]  irb(main):278:0>sql="insert signals_rmas (groupsnorm_id, arraydb_id, probeset_id,signal,updated_at,created_at) values #{inserts.join(", ")}" => "insert signals_rmas (groupsnorm_id, arraydb_id, probeset_id,signal,updated_at,created_at) values (1,2,3,4,5,6), (7,8,9,10,11,12)"  irb(main):279:0> conn.execute sql    (0.4ms)  insert signals_rmas (groupsnorm_id, arraydb_id, probeset_id,signal,updated_at,created_at) values (1,2,3,4,5,6), (7,8,9,10,11,12) activerecord::statementinvalid: sqlite3::sqlexception: near ",": syntax error: insert signals_rmas (groupsnorm_id, arraydb_id, probeset_id,signal,updated_at,created_at) values (1,2,3,4,5,6), (7,8,9,10,11,12) 

what problem? how can insert multiple records time in sql?(create record) in advance

it looks sqlite doesn't support inserting multiple records.

https://stackoverflow.com/a/5009740/199712