how to input special character "," on sqlite android?

Question

i have script for insert multiple rows :

protected static final String INSERT_NAME_LIST1 = "insert into Table_Name(name1,name2) VALUES (1,'aa'),(1,'bb'),(1,'cc');";

But i have error :

06-21 14:15:31.155: E/AndroidRuntime(12798): Caused by: android.database.sqlite.SQLiteException: near "','": syntax error: insert into Table_Name(name1,name2) VALUES (1,'aa')',' (1,'bb')',' (1,'cc');

please help me, how to fixed error ???

score 2 · Answer 1 · edited May 23 '17 at 12:20

2

you can do it easily in noramally in SQL but in SQLite I think can try this in which it recast into sqlite as:

Is it possible to insert multiple rows at a time in an SQLite database?

edited May 23 '17 at 12:20

Community

1
1

answered Jun 21 '12 at 08:20

Dheeresh Singh

15,570
3
36
36

tsukimi · Accepted Answer · 2012-06-21T08:22:53.463

1

I think you can only have one set on values in the statement

protected static final String INSERT_NAME_LIST1 = "insert into Table_Name(name1,name2) VALUES (1,'aa');";

Multiple inserts can be done with a union

 INSERT INTO 'Table_Name'
 SELECT 1 AS 'name1', 'a' AS 'name2'
 UNION SELECT 2, 'b'
 UNION SELECT 3, 'c'
 UNION SELECT 4, 'd'

edited Jun 21 '12 at 08:22

answered Jun 21 '12 at 08:16

tsukimi

1,595
2
19
35

how to input special character "," on sqlite android?

2 Answers2