UPDATE vs UPDATE WHERE

Viewed 344

I have a table with many rows, where I periodically want to set one column to 0 using a cron.

What is faster / less memory consuming, doing an UPDATE on all rows (ie. no WHERE clause) or doing an UPDATE only WHERE mycolumn != 0?

1 Answers
Related