Thanks John, that's done the trick On Mon, 2009-09-07 at 18:24 +0100, John Daisley wrote: > Add the option 'safe-updates' to the mysql section of your 'my.cnf' / > 'my.ini' file and restart the mysqld service. > > [mysql] > Safe-updates > > Regards > > John Daisley > Mobile +44(0)7812 451238 > Email j...@butterflysystems.co.uk > > Certified MySQL 5 Database Administrator (CMDBA) > Certified MySQL 5 Developer > Cognos BI Developer > > ----------------------- > Sent from HP IPAQ mobile device. > > > > -----Original Message----- > From: Ian Simpson <i...@it.myjobgroup.co.uk> > Sent: Monday, September 07, 2009 5:14 PM > To: mysql@lists.mysql.com > Subject: Prevent execution of queries without a WHERE clause > > Hi all, > > I vaguely recall finding mention a MySQL command or start-up option that > blocked any update or delete query that didn't have a WHERE component, > to prevent statements accidentally affecting too many rows (like those > of a certain absent-minded web developer who might work for the same > company as me...). I now can't find any reference to it, other than a > vague mention of using safe mode in the comments in the mysql docs; it > doesn't explain if that is starting with --safe-mode, or using the > mysqld_safe script. Both of these modes seem remarkably poorly > documented, making me unwilling to experiment with them without advice, > in case one of them disables networking or something similar. > > Hoping someone can help with this. > > Thanks > -- > Ian Simpson > System Administrator > MyJobGroup > > -- Ian Simpson System Administrator MyJobGroup
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
