in reply to Re^2: DBI selectall_arrayref
in thread DBI selectall_arrayref

But they are quoted here from perl - these backticks would go to the SQL engine. Recently I've switched to PostgreSQL so I can't check it but perhaps MySQL uses them for quoting fields with spaces in them.

Replies are listed 'Best First'.
Re^4: DBI selectall_arrayref
by Juerd (Abbot) on Sep 05, 2004 at 19:39 UTC

    In SQL, 'foo' is a string. "foo" is a quoted identifier. In MySQL, 'foo' is a string, and "foo" is also a string. So they made the identifier quotation mark the backtick, resulting in `foo`. MySQL isn't SQL :(

    Juerd # { site => 'juerd.nl', plp_site => 'plp.juerd.nl', do_not_use => 'spamtrap' }

[reply]

In Section Seekers of Perl Wisdom