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:
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
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
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
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
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
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:
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
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)