On 24 May 2014, at 11:08am, Humblebee <[email protected]> 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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to