[sqlite] How to update a whole column

[James W. Walker]

What is the fastest way to change the values in one column in every 
row?  What I thought of was like so:

BEGIN TRANSACTION;
UPDATE MyTable SET TheCol=7 WHERE keyCol=1;
UPDATE MyTable SET TheCol=8 WHERE keyCol=2;
... and so on for each row
COMMIT;
--
  James W. Walker, ScriptPerfection Enterprises, Inc.
  <http://www.write-brain.com/>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]