Re: Prevent execution of queries without a WHERE clause

Hi Darren, Once I knew the name of the command I could Google it and find all the relevant documentation, so I've put additional directives in place to override the limits on SELECTS. Thanks for the thought, though. On Tue, 2009-09-08 at 15:32 +0100, Darren Cassar wrote: > Hi, > > You can check

Re: Prevent execution of queries without a WHERE clause

Hi, You can check this feature out on section 2.9 on the mysql 5.0 certification guide (page 44). this feature has some side effects other than requesting a where with deletes and updates i.e. Quoting for whoever doesn't have the MySQL certification study guide 1.UPDATE and DELETE statments are a

RE: Prevent execution of queries without a WHERE clause

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 >

RE: Prevent execution of queries without a WHERE clause

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