How to insert multiple values in single cell database table in android?

Question

I am developing an android database application in which i have to add multiple values in single cell of database table like

id| col 1     | col2     |
  | 1,2,3,4   | a,b,c,d  |
  | 1,1,1,1   | ,x,x,x,x |
  |           |          |

i have created the database in SQLite Database Browser

how can i achieve this

Insert as a string from Java, use join if you have those in an array. — Pentium10
– Pentium10, Commented Nov 30, 2011 at 7:04

Zsombor Erdődy-Nagy · Accepted Answer · 2011-11-30 07:04:46Z

1

You need to serialize the data that you'd like to load into that cell, for example into xml, json, or maybe csv if that suits you. Xml could get a bit messy, for json there's the Gson lib that makes things really easy, and csv is quite straighforward if your data is simple enough.

answered Nov 30, 2011 at 7:04

Zsombor Erdődy-Nagy

16.9k16 gold badges80 silver badges105 bronze badges

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

Comments

Rajdeep Dua · Accepted Answer · 2011-11-30 07:10:40Z

1

Use JSON and store it as a String. I would want to seriously take a look why you want to do that though

answered Nov 30, 2011 at 7:10

Rajdeep Dua

11.2k2 gold badges34 silver badges22 bronze badges

Collectives™ on Stack Overflow

How to insert multiple values in single cell database table in android?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related