Error in inserting multiple records to SQLite database using Javascript

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 http://stackoverflow.com/a/5009740/1466009...it contains the exact query for inserting multiple set of data — aravind varma, Aug 31 '12 at 05:24

score 1 · Accepted Answer · edited Aug 31 '12 at 09:16

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 '12 at 09:16

ЯegDwight

24,821
10
45
52

answered Aug 31 '12 at 04:44

Daniel Jonker

844
10
21

I have tried, same error am getting – tilak Aug 31 '12 at 04:45
have you tried putting a decimal on the max_points? – Daniel Jonker Aug 31 '12 at 04:48

score 0 · Answer 2 · edited May 23 '17 at 11:52

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 '17 at 11:52

Community

1
1

answered Mar 06 '13 at 14:42

goosfraba

80
1
8

1

You should flag the question as duplicate rather than answering it with just a link. – James Donnelly Mar 06 '13 at 15:03

Error in inserting multiple records to SQLite database using Javascript

2 Answers2