Safe updates are too restrictive
I have safe updates turned on so I don't accidently blow away another 80,000 rows again. However I'm trying to run the following update and it's not letting me
update users set subscription = 'Free' where subscription is null or subscription = '';
The primary key in this table is the uID. How am I supposed to run this simple update, when I'm already using a very specific where clause?
You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column