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