http://www.perlmonks.org?node_id=425114


in reply to database table named 'with'

No, there is nothing special about the way perl is handling it. "with" is a reserved word in mysql, as shown here. The solution is to surround "with" with backticks (`) as described here. Thus your query would become something like:

my $sth = $dbh->prepare("insert into blah (...,`with`) values(?,?)"); ...