NYCPHP Meetup

NYPHP.org

[nycphp-talk] Data import from MySQL 3.23 to MySQL 4.0

Hans Zaunere hans at nyphp.com
Fri Jan 7 11:17:47 EST 2005


> > And, incedentally, if you're using mysqldump to export the data,
there's
> > an option to force backticks on table and column names:
> 
> A bad idea.  Using reserved words will cause you major grief in the
long
> run.  Here's a great reference on naming conventions, including a list
of
> reserved words:  http://www.dbazine.com/gulutzan5.shtml

That's a great article, and since it's written by the MySQL's SQL
Standards Engineer, you can be sure that the article is a best practice
for using MySQL moving forward.

H




More information about the talk mailing list