From the little bit you've shown us, << the right syntax to use near '"articles_table"' >> would indicate that your MySQL connection via DBI has not enabled any of the modern defaults. The original identifier-quoting character for MySQL is backquote ` and it treats double quotes as string literals. You have to run statements at startup to get your connection to be more standard compliant. I have this DBI connection config in all my apps: 
RaiseError => 1,
AutoCommit => 1,
ShowErrorStatement => 1,
quote_names => 1,
quote_identifiers => 1,
mysql_enable_utf8 => 1,
on_connect_call => 'set_strict_mode',

[download]

Without that last 'set_strict_mode', mysql does all sorts of horrible things like silently truncating strings or inserting zeroes into datetime fields. I think it also controls whether the identifier-quoting character is MySQL's backquote or the SQL standard doublequote.

It does what you expect in your database browser app probably because that app initializes the connection differently.

In reply to Re: Need advice how to diagnose the problem when syntax using MAX() is correct according to MySQL monitor, but errors out in DBI by NERDVANA
in thread [SOLVED] Need advice how to diagnose the problem when syntax using MAX() is correct according to MySQL monitor, but errors out in DBI by dissident

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.