[Resolved] MySQL --safe-updates

bubblenut

Is there a way of setting safe-updates through PHP?

mrhappiness

you mean something like transactions?

you perhpas can lock all the tables you need, do all the stuff that needs to be done and unlock the tables afterwards

bubblenut

no there is a mysql option called --safe-updates (or --i-am-a-dummy) you can see it here
Cheers
Bubble

mrhappiness

try

mysql_query('SET SQL_SAFE_UPDATES=1') or die(mysql_error());

perhaps it will work

in phpmyadmin it does (but only if i enter

SET SQL_SAFE_UPDATES=1;
UPDATE table SET column = column +1

if i do two statements it will still change the table; maybe it works within php)

good luck

bubblenut

Cheers

mrhappiness

i live to please 🙂

but why do you need this?

if you write your php script you can make sure that you use a where-clause can't you?

mtimdog

The link provided reads "a useful startup option "....Granted, some startup options can be set at runtime, but there is no indication that this one can since the example uses a shell script

shell> mysql --safe-updates --select_limit=500 --max_join_size=10000

to start mysql.

mrhappiness

it can be set at runtime, i just have tested it

bubblenut

Originally posted by mrhappiness
but why do you need this?

My boss asked me to check it out after I accidentally updated all the product images to blanks and he had to rebuild the database. I think it may have been in reference to the --i-am-a-dummy alternative 🙁
Bubble