NYCPHP Meetup

[Ajai Khattri]

Allen Shaw wrote:

> And, incedentally, if you're using mysqldump to export the data, 
> there's an option to force backticks on table and column names:
>
> |--quote-names, -Q|
>     Quote database, table, and column names within ``' characters. If
>     the server SQL mode includes the |ANSI_QUOTES| option, names are
>     quoted within `"' characters. As of MySQL 4.1.1, |--quote-names|
>     is on by default, but can be disabled with |--skip-quote-names|.
>

Good to know - this is a much better way to do the import :-)

Thanks very much!

-- 
Aj.
Systems Administrator / Developer