On 19-Apr-2013, at 9:14 AM, Doug <doug@stripped> wrote:
> why these db names created fail but the last one gets success?
> mysql> create database 3208e1c6aa32;
> mysql> create database 208e1c6aa32;
> mysql> create database 08e1c6aa32;
> mysql> create database 8e1c6aa32;
These are not working because MySQL is interpreting the database names as expressions.
Look closely at the db names:
> mysql> create database e1c6aa32;
> Query OK, 1 row affected (0.01 sec)
This works fine.
Don't use database names starting with integers unless you use back ticks.
This will work for you:
mysql> create database `3208e1c6aa32`;
Though I would recommend not using such names. Some poor guy working on your application
six months down the line is going to wonder why his queries are failing, spend a day
trying to figure out and will post the same question again to this list :-)
Managing Director @ Ask DB Experts