Error in inserting multiple records to SQLite database using Javascript [duplicate]

Question

I am developing a application for Android using PhoneGap. I am trying to insert multiple records to table in a single query using Javascript. I am getting a error like syntax error near ",".

My Code :

tx.executeSql('CREATE TABLE IF NOT EXISTS MAX_POINTS (Days INTEGER UNIQUE, Max_Point FLOAT)');      
sqlQuery = 'INSERT INTO MAX_POINTS(Days,Max_Point) VALUES(1,32),(2,35)';
tx.executeSql(sqlQuery);

the query for inserting multiple sets of data is not correct.....i suggest to go through stackoverflow.com/a/5009740/1466009...it contains the exact query for inserting multiple set of data — aravind varma
– aravind varma, Commented Aug 31, 2012 at 5:24
I believe user fearless_fool already replied to that here: <stackoverflow.com/questions/1609637/…> — goosfraba
– goosfraba, Commented Mar 6, 2013 at 14:40

ЯegDwight · Accepted Answer · 2012-08-31 09:16:09Z

1

Is it that you're missing the semicolon? Or that the values inserted into the float field are integers?

sqlQuery = 'INSERT INTO MAX_POINTS(Days,Max_Point) VALUES(1,32),(2,35)';

Should be:

sqlQuery = 'INSERT INTO MAX_POINTS(Days,Max_Point) VALUES(1,32.0),(2,35.0);';

edited Aug 31, 2012 at 9:16

ЯegDwight

25.3k10 gold badges47 silver badges52 bronze badges

answered Aug 31, 2012 at 4:44

Daniel Jonker

85410 silver badges21 bronze badges

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

2 Comments

tilak Over a year ago

I have tried, same error am getting

Daniel Jonker Over a year ago

have you tried putting a decimal on the max_points?

Community · Accepted Answer · 2017-05-23 11:52:23Z

0

I believe user fearless_fool already replied to that here: Is it possible to insert multiple rows at a time in an SQLite database?

edited May 23, 2017 at 11:52

CommunityBot

11 silver badge

answered Mar 6, 2013 at 14:42

goosfraba

801 silver badge8 bronze badges

1 Comment

James Donnelly Over a year ago

You should flag the question as duplicate rather than answering it with just a link.

Collectives™ on Stack Overflow

Error in inserting multiple records to SQLite database using Javascript [duplicate]

2 Answers 2

2 Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Linked

Related