At 17:38 +0200 5/31/06, Gilles MISSONNIER wrote:
Thank you Paul DuBois.
I have 2 questions for you :
1-Why the error code (1064) can't lead explicitly to the syntax problem ?
I'm sorry, I don't understand the question.
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 ]
It sounds like you mean, "When I have a problem, how can I instantly
find the solution?" I don't think I can answer that.
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 !!
No, not all keywords are reserved. The list at the bottom of
http://dev.mysql.com/doc/refman/4.1/en/reserved-words.html
shows some examples.
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]
--
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]