Thank you Paul DuBois.
I have 2 questions for you :
1-Why the error code (1064) can't lead explicitly to the syntax problem ?
2-Could you tell me how I could go directly to the relevant page ?
[ Hard for you to feel like a lambda user in MySQL ]
my comment :
The "Search the MySQL manual" works when you know where is the
problem.
Funny that the keywords were in my question to the list :
"DEC column name forbidden", but did not made sens to me to query with
these word.
first, I tried on the error code [ ERROR 1064 (42000) ] : not
understandable to me.
then I tried "keyword DEC" (matching all of the words)
2 pages : helpless
then I tried "keyword list"
17 pages, off topics [ from excerpt ]
-
Now If you ask me why I used "keyword DEC" instead of "reserved word"
the answer is right in the begining of the page :
http://dev.mysql.com/doc/refman/4.1/en/numeric-types.html
"keyword DEC" or "reserved word DEC" are the same !!
for instance :
"The keyword INT is a synonym for INTEGER, and the keyword DEC
is a synonym for DECIMAL. bla bla bla ..."
Regards.
======================================================================
On Tue, 30 May 2006, Paul DuBois wrote:
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
=_==_==_==_==_==_=
=¯==¯==¯==¯==¯==¯=
Gilles Missonnier
IAP - [EMAIL PROTECTED]
01 44 32 81 36
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
