You are right, the "DEC" is a reserved keyword in the MySQL system.
We use "DE" in our databases, which will be better then "DECL".
cheers,
Gilles MISSONNIER wrote:
Hello
I could not find the answer through the online "Search the MySQL manual".
I run MySQL 4.1
In astronomy, RA and DEC are widely used coordinate names.
Then I try to add a column named "DEC" :
mysql> alter table my_table add dec float;
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'dec float' at line 1
UPPER case lead to the same error.
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.
Is there a turn around ?
This is annoying ; I add to name the column as "DECL" which is much less
meaning full in the astronomy community.
thanks,
=_==_==_==_==_==_=
=¯==¯==¯==¯==¯==¯=
Gilles Missonnier
IAP - [EMAIL PROTECTED]
------------------------------------------------------------------------
--
=================================================================
Chenzhou Cui
National Astronomical Observatory | Tel: (8610)64841695/64872500
Chinese Academy of Sciences | FAX: (8610)64878240
Datun Road 20A, Chaoyang District | Email: [EMAIL PROTECTED]
Beijing 100012, China | WWW: www.lamost.org/~cb
=================================================================
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]