At 15:46 +0200 5/30/06, Gilles MISSONNIER wrote:
Hello
I could not find the answer through the online "Search the MySQL manual".
I run MySQL 4.1
In the 4.1 manual, the reserved words are listed here:
http://dev.mysql.com/doc/refman/4.1/en/reserved-words.html
"DEC" is in the list.
Identifier-quoting guidance is here:
http://dev.mysql.com/doc/refman/4.1/en/legal-names.html
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]
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]