9 messages in com.mysql.lists.mysqlRE: set "DEC" as a column name : forb...
FromSent OnAttachments
Gilles MISSONNIER30 May 2006 06:46 
Jay Blanchard30 May 2006 06:50 
Thomas Lundström30 May 2006 07:21 
Chenzhou CUI30 May 2006 18:55 
Paul DuBois30 May 2006 19:19 
Gilles MISSONNIER31 May 2006 08:37 
Paul DuBois31 May 2006 08:56 
Gilles MISSONNIER31 May 2006 10:46 
Jeremy Cole31 May 2006 14:48 
Subject:RE: set "DEC" as a column name : forbidden
From:Jay Blanchard (jbla@pocket.com)
Date:05/30/2006 06:50:54 AM
List:com.mysql.lists.mysql

[snip] It seems that the reason is that "DEC" is a keyword standing for "decimal". I do not understand why this cannot be allowed for a column name. [/snip]

There are several reserved keywords in MySQL, none of which are recommended for column names. You can try the SQL statement using backticks around the proposed column name to see if that will work, but you may have conflicts later. Of course, you could always call the column by its full name, declination.