Re: I can't have group as a column name in a table? [SOLVED]

2011-02-25 Thread Dave M G
Aveek, Simcha, Johan, Thanks for explaining the situation. I knew there were some reserved words, but I hadn't realized there were so many. Anyway, now that I know I can protect my column names with backticks, I'm good to go. -- Dave M G -- MySQL General Mailing List For list archives:

I can't have group as a column name in a table?

2011-02-24 Thread Dave M G
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

Re: I can't have group as a column name in a table?

2011-02-24 Thread Aveek Misra
Use a quote around the column name or explicitly specify the column as table.column (as for e.g. mytable.group) in the query. For more details refer to http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html Thanks Aveek On Feb 24, 2011, at 4:36 PM, Dave M G wrote: MySQL users, Simple

Re: I can't have group as a column name in a table?

2011-02-24 Thread Jo�o C�ndido de Souza Neto
Have you read about reserved words in MySql? http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html -- João Cândido de Souza Neto Dave M G d...@articlass.org escreveu na mensagem news:4d663ba0.5090...@articlass.org... MySQL users, Simple question: In one table in my database, the

Re: I can't have group as a column name in a table?

2011-02-24 Thread Simcha Younger
On Thu, 24 Feb 2011 16:43:56 +0530 Aveek Misra ave...@yahoo-inc.com wrote: Use a quote around the column name or explicitly specify the column as table.column (as for e.g. mytable.group) in the query. For more details refer to http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html use

Re: I can't have group as a column name in a table?

2011-02-24 Thread Johan De Meersman
On Thu, Feb 24, 2011 at 12:06 PM, Dave M G d...@articlass.org wrote: 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? As several people already pointed out, simply use backticks. Simple quotes have

Re: I can't have group as a column name in a table?

2011-02-24 Thread Jo�o C�ndido de Souza Neto
The best comparison I´ve never seen in my life was the TNT. LOL -- João Cândido de Souza Neto Johan De Meersman vegiv...@tuxera.be escreveu na mensagem news:AANLkTikPeVuTpj9E0iepFncCJZQOF6sn_dbrhp0=p...@mail.gmail.com... On Thu, Feb 24, 2011 at 12:06 PM, Dave M G d...@articlass.org wrote:

Re: I can't have group as a column name in a table?

2011-02-24 Thread mos
At 05:13 AM 2/24/2011, you wrote: Use a quote around the column name or explicitly specify the column as table.column (as for e.g. mytable.group) in the query. For more details refer to http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html Thanks Aveek Hmmm. Everyone has given me a

Re: I can't have group as a column name in a table?

2011-02-24 Thread Jo�o C�ndido de Souza Neto
LOL -- João Cândido de Souza Neto mos mo...@fastmail.fm escreveu na mensagem news:6.0.0.22.2.20110224093057.044a0...@mail.messagingengine.com... At 05:13 AM 2/24/2011, you wrote: Use a quote around the column name or explicitly specify the column as table.column (as for e.g. mytable.group)