as you know mysql gives you an error to check your sql syntax when it doesn't understand a query but does not log it , but you can have your application (php, perl, etc ) accessing mysql to log any bad/malformed queries...
Kishore Jalleda On 3/10/06, ryan lwf <[EMAIL PROTECTED]> wrote: > Hi Dan, > > Noted with thanks. > > As such, is there a workaround to log problematic sql queries ran against > the mysqld server ? Do I need to write separate script to do this ? > > Regards, > Ryan. > > On 3/10/06, Dan Nelson <[EMAIL PROTECTED]> wrote: > > > > In the last episode (Mar 08), ryan lwf said: > > > I understand that the option log-errors and log-warnings only logs > > > server related internal errors. How do I enable logging errors from > > > queries executed, so that I can fix the problematic query statement > > > accordingly? > > > > > > The statement "SHOW WARNINGS" and "SHOW ERRORS" does not work on my > > > server with mysqld-4.0.25 binary version. > > > > Those commands appeared in MySQL 4.1. Before then, warnings were > > simply counted. > > > > -- > > Dan Nelson > > [EMAIL PROTECTED] > > > >
