mercredi 7 octobre 2015

SQLite batch update of a column in a table

I am using SQLite and have the following SQL Statement which updates column active with true for just row 28.

update "customer" set "active"='true' where rowid=28

What I would like to do is batch update the entire customer table, active column to true. I would have thought a loop was the best method, but I don't think sqlite supports loops. Anyone advise me how I can update a column in a table so all the records contain the value the in them?

Thanks

Aucun commentaire:

Enregistrer un commentaire