No such thing as a small change | |
PerlMonks |
Re: Deleting Old MySql Records With PERLby perlfan (Vicar) |
on Jul 13, 2016 at 21:02 UTC ( [id://1167732]=note: print w/replies, xml ) | Need Help?? |
If your the column with your date in it is really called date, you're gonna have a bad time. Try putting the column name date in back ticks:
(untested, but exemplifies what I am saying): Furthermore, make sure that column `date` is of the right column type (DATE or DATETIME). Finally, I test my SQL using the mysql client; if it succeeds there, it should succeed in your Perl script.
In Section
Seekers of Perl Wisdom
|
|