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 = '';
You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
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?
by turning off that safe mode
Yes, of course. But what good is a safe mode if it can only be used in updates where uID equals something?
that's a very good question, i hope you find an answer