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