Naming Table Fields

[BestWD]

I always have problems with naming table fields. I know there are some names that you can't use, otherwise queries don't work. Well, I always end up using something I shouldn't, and I spend forever trying to figure out why my site doesn't work! :P Is there anywhere I can find a list of words not to use??

Thanks!
Sandy

[RTH10260]

Is there anywhere I can find a list of words not to use??Technically you are free to use any names that match the applications domain. If they clash with predefined 'reserved' words of the sql language and MySql extensions, you can code the names in quotes.SELECT 'select' from 'table' where 'where' = 12345;Names may even have embedded quotes ! The extra set of quotes may make construction and reading of a sql statement a challenge in some scripting languages.

Check here: http://dev.mysql.com/doc/mysql/en/reserved-words.html
and http://dev.mysql.com/doc/mysql/en/legal-names.html