Re: MySQL KeyWords WorkAround

[Mike Hillyer]

Use back-ticks to quote the identifier:

CREATE TABLE TEST (`LEFT` INT);

Better to avoid using the keyword so you don't have to remember back-ticks every single time you want to refer to it.

Mike Hillyer, Technical Writer
MySQL AB, www.mysql.com
Office: [phone]

Blog: http://www.openwin.org/mike

"The Open Source movement has become a major force across the software industry, and MySQL is the world's most popular open source database."
--Fortune Magazine