Safe updates are too restrictive

Databases
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?

2

by turning off that safe mode

3

Yes, of course. But what good is a safe mode if it can only be used in updates where uID equals something?

4

that’s a very good question, i hope you find an answer :smiley: