| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Dave M G | Date: | February 24 2011 11:06am |
| Subject: | I can't have "group" as a column name in a table? | ||
| View as plain text | |||
MySQL users,
Simple question:
In one table in my database, the column was named "group".
I kept getting failed query errors until I renamed the column.
I've never before encountered a situation where MySQL mistook a column
name for part of the query syntax.
Should I never use the word "group" for column names? Seems a little
silly. Is there a way to protect column names to that there is no confusion?
--
Dave M G
| Thread | ||
|---|---|---|
| • I can't have "group" as a column name in a table? | Dave M G | 24 Feb |
| • Re: I can't have "group" as a column name in a table? | Aveek Misra | 24 Feb |
| • Re: I can't have "group" as a column name in a table? | Simcha Younger | 24 Feb |
| • Re: I can't have "group" as a column name in a table? | mos | 24 Feb |
| • Re: I can't have "group" as a column name in a table? [SOLVED] | Dave M G | 25 Feb |
| • Re: I can't have "group" as a column name in a table? | joao | 24 Feb |
| • Re: I can't have "group" as a column name in a table? | Johan De Meersman | 24 Feb |
| • Re: I can't have "group" as a column name in a table? | joao | 24 Feb |
| • Re: I can't have "group" as a column name in a table? | joao | 24 Feb |
