> Put mulitple record into your table and see what > occurs..... D:\temp\convention>sqlite3 test.db SQLite version 3.0.8 Enter ".help" for instructions sqlite> create table t (a, b); sqlite> insert into t (a, b) values ('foo', 'bar'); sqlite> insert into t (a, b) values ('test', '2'); sqlite> select * from t; foo|bar test|2 sqlite> update t set a = 'foo;qux', b = 'barr' where a = 'foo'; sqlite> select * from t; foo;qux|barr test|2 sqlite>
works fine here.