Web SQL insert data into multiple rows

Question

I've tried to insert variables into multiple rows at once in Web SQL database but with all known to me methods I'm getting errors:

("INSERT INTO tab (a,b) VALUES (?,?),(?,?)",[v1,v2,v3,v4])
>> could not prepare statement (1 near ",": syntax error)

("INSERT INTO tab (a,b) VALUES (?,?,?,?)",[v1,v2,v3,v4])
>> could not prepare statement (1 4 values for 2 columns)

("INSERT INTO tab (a,b) VALUES (?,?)",[v1,v2,v3,v4])
>> number of '?' does not match arguments count

Which one is correct for Web SQL and where is my mistake?

Deepshikha · Accepted Answer · 2013-10-20 13:33:58Z

4

As table tab has two columns you can specify only two values to be inserted as a row not 4. Following query will work:

("INSERT INTO tab (a,b) VALUES (?,?)",[v1,v2])

You can execute this query multiple times in a single transaction to add multiple rows to improve performance of overall query and ensure integrity. Hope this helps!!!

edited Oct 20, 2013 at 13:33

answered Oct 20, 2013 at 13:27

Deepshikha

10.3k2 gold badges24 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Lapsio Over a year ago

I know but i want to put many rows in one sql query //thanks, question was not clear - edited

Lapsio Over a year ago

queries are asynchronous, aren't they? So If I'd like to fire callback after all of them I'd need to count how many successed and how many failed. for 1000 entries at once it doesn't seem to be best solution

Deepshikha Over a year ago

Inserting multiple rows in one INSERT statement is not supported in WEB SQL. You can refer to this link stackoverflow.com/questions/10031605/…

Lapsio Over a year ago

mhm... :C thanks for answer, I hope it won't be performance bottleneck

Matthieu Over a year ago

Actually, the first syntax works in some implementations, like Safari. See gpickin.com/index.cfm/blog/…

Collectives™ on Stack Overflow

Web SQL insert data into multiple rows

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related