On 24 May 2014, at 11:08am, Humblebee <fantasia.d...@gmail.com> wrote:

> I looked up the SQLite
> documentation and found that Insert works on multiple rows.  Can I
> update multiple rows with one statement ?

No.  But if you do not already understand BEGIN and END you should read about 
them.

Doing 

BEGIN ... UPDATE ... UPDATE ... UPDATE ... END

if much faster than doing

UPDATE ... UPDATE ... UPDATE

.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to