busboy — 2011-05-17T00:49:28-04:00 — #1
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?
r937 — 2011-05-17T01:13:47-04:00 — #2
by turning off that safe mode
busboy — 2011-05-17T09:20:18-04:00 — #3
Yes, of course. But what good is a safe mode if it can only be used in updates where uID equals something?
r937 — 2011-05-17T09:35:36-04:00 — #4
that's a very good question, i hope you find an answer