Re: How to disable some of the mysql query?

2008-11-29 Thread Chandru
Hi wayne, If you dont want any query with select * from table by mistake then you can start the mysql by using the command --safe-updates or --i-am-a-dummy this does not allow queries to be executed if they dont have any where clause. Regards, Chandru www.mafiree.com On Fri, Nov 28, 2008 at

Re: How to disable some of the mysql query?

2008-11-28 Thread Steve Edberg
At 1:07 AM +0800 11/29/08, Wayne wrote: for example,one user has the 'select' right on talbe 'test'(innodb,million records),however,he sometimes execute query like 'select * from test'.That will slow down the whole database. Is there a way to disable some queries for some users? Or,mysql's