Hi,

I just have some trouble with column names in MySQL database.

For instance, I can't create a column named "Right"!

Another example: If the column contains a '.' (full stop) or a '/' (slash) I get an error message.

Is there a list of reserved strings or chars I'm not allowed to use as column names?

Chris

Hi Chris,

'Right' is reserved word in Mysql that's why you are not allowed to create column with that name.

Check below link for list of Mysql reserved words:
http://www.brainbell.com/tutorials/M...rved_Words.htm

Thanks,

Thanks a lot!

That's exactly what I'm looking for.

btw: For instance, if a columnname contains a full stop or a slash you have set the name in backticks ``! Then it works

Chris

My recommendation: don't do it!
Choose a different name instead, you will save yourself a lot of trouble!

Additionally the SQL with the backtick is not portable. You will have a hard time if you need to run that on a DBMS that uses ANSI quoting. The standard for quoting names with special characters is the double quote, e.g "some.column"