Re: Prevent execution of queries without a WHERE clause

2009-09-08 Thread Ian Simpson
> Sent from HP IPAQ mobile device. > > > > > > > > -Original Message- > > From: Ian Simpson > > Sent: Monday, September 07, 2009 5:14 PM > > To: mysql@lists.mysql.com > > Subject:

Re: Prevent execution of queries without a WHERE clause

2009-09-08 Thread Darren Cassar
> > Sent from HP IPAQ mobile device. > > > > > > > > -Original Message- > > From: Ian Simpson > > Sent: Monday, September 07, 2009 5:14 PM > > To: mysql@lists.mysql.com > > Subject: Prevent execution of queries without a WHERE cl

RE: Prevent execution of queries without a WHERE clause

2009-09-08 Thread Ian Simpson
> > > -Original Message- > From: Ian Simpson > 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

RE: Prevent execution of queries without a WHERE clause

2009-09-07 Thread John Daisley
A) Certified MySQL 5 Developer Cognos BI Developer --- Sent from HP IPAQ mobile device. -Original Message- From: Ian Simpson 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 va

Prevent execution of queries without a WHERE clause

2009-09-07 Thread Ian Simpson
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 compan