I have my own log table which contains a Text column that is suppose to
store SQL statements that fail to execute properly. My problem is when I
use an
Insert into LogTable set SQL='select 'abc' from table;-- this comment
screw's things up;#13#10update table x set v='ddd';...'
I get all sorts of problems because of the quotes, comments and ";" that is
embedded in the SQL is being interpreted as another SQL command. Is there
any easy way of implementing this? Or am I going to have to escape every
quote, ';', and '"' in the sql value?
TIA
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
