in reply to Easy way to clear a mysql table?
What part of your question relates to Perl? Have you tried running your SQL statement outside of Perl?
What steps have you taken to ensure that your statement is correct?