List:General Discussion« Previous MessageNext Message »
From:Simcha Younger Date:February 24 2011 11:24am
Subject:Re: I can't have "group" as a column name in a table?
View as plain text  
On Thu, 24 Feb 2011 16:43:56 +0530
Aveek Misra <aveekm@stripped> 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 backticks, not quotes. 
`group`, not 'group'.


-- 
Simcha Younger <simcha@stripped>
Thread
I can't have "group" as a column name in a table?Dave M G24 Feb
  • Re: I can't have "group" as a column name in a table?Aveek Misra24 Feb
    • Re: I can't have "group" as a column name in a table?Simcha Younger24 Feb
    • Re: I can't have "group" as a column name in a table?mos24 Feb
    • Re: I can't have "group" as a column name in a table? [SOLVED]Dave M G25 Feb
  • Re: I can't have "group" as a column name in a table?joao24 Feb
  • Re: I can't have "group" as a column name in a table?Johan De Meersman24 Feb
  • Re: I can't have "group" as a column name in a table?joao24 Feb
  • Re: I can't have "group" as a column name in a table?joao24 Feb