MySQL 5 logging

[Sarky78]

Hi

Does anyone know if out of the box mySql logs incorrect sql statements?

I say incorrect sql statements as i've made an error in a bit of code for a registration site, and need to get the sql statements that would have acted upon the database, correct them and action them against the db again.

Any ideas?

Tony

 

[DonQuichote]

No, but every programming interface you use can check for errors. And should, off course. MySQL can log all queries or just the slow ones, but I do not know of a function to log just the incorrect ones.