[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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]