WampServer
Apache, PHP, MySQL
on Windows
MySQL query browser bug?
Posted by:
rambutan
(---.bredband.comhem.se)
Date: October 11, 2007 12:20AM
When I have a table named with numbers I cant add posts to the table.
You cant press the edit button. And you cant add posts eather.
Screenshot:
[aycu30.webshots.com]
A bug? Or what do I do wrong?
You cant press the edit button. And you cant add posts eather.
Screenshot:
[aycu30.webshots.com]
A bug? Or what do I do wrong?
Re: MySQL query browser bug?
Posted by:
toivo
(203.19.130.---)
Date: October 11, 2007 02:18AM
Hi,
It may be best to avoid numbers as identifiers, see the MySQL reference manual at [dev.mysql.com]
It says: "It is recommended that you do not use names of the form Me or MeN, where M and N are integers. For example, avoid using 1e or 2e2 as identifiers, because an expression such as 1e+3 is ambiguous. Depending on context, it might be interpreted as the expression 1e + 3 or as the number 1e+3."
Using just numbers may make identifiers like table names even more ambiguous and confuse the database engine :-)
Regards,
toivo
Sydney, Australia
It may be best to avoid numbers as identifiers, see the MySQL reference manual at [dev.mysql.com]
It says: "It is recommended that you do not use names of the form Me or MeN, where M and N are integers. For example, avoid using 1e or 2e2 as identifiers, because an expression such as 1e+3 is ambiguous. Depending on context, it might be interpreted as the expression 1e + 3 or as the number 1e+3."
Using just numbers may make identifiers like table names even more ambiguous and confuse the database engine :-)
Regards,
toivo
Sydney, Australia
Sorry, only registered users may post in this forum.
