in reply to Mysql: need to escape column names

You probably want $sth->quote_identifer instead of quote.
Perl 6 - links to (nearly) everything that is Perl 6.

Replies are listed 'Best First'.
Re^2: Mysql: need to escape column names
by jeanluca (Deacon) on Aug 08, 2010 at 08:27 UTC
    Yep, thats it for the identifiers!!

    One last thing, is there also a solution for the definition of the column ? Because the user defines the column name and its definition (for example: VARCHAR(100) NOT NULL)

    What would be the best way to process these ?