samedi 21 mars 2015

Update statement for a list of strings

I'm using sqlite3 and my table has a text field that actually has a list of strings.


So a sample select (select * from table where id=1) would return for example



1|foo@bar.com|21-03-2015|["foo", "bar", "foobar"]


I couldn't figure out how the sqlite statement for updating the list is though. I tried



update table set list="["foo", "bar"] where id=1;
update table set list=["foo", "bar"] where id=1;
update table set list="\["foo", "bar"\]" where id=1;
update table set list=(value) where id=1 VALUES (["foo", "bar"])

Aucun commentaire:

Enregistrer un commentaire