List:General Discussion« Previous MessageNext Message »
From:Doug Date:April 19 2013 3:44am
Subject:help with mysql db names
View as plain text  
Hello,

why these db names created fail but the last one gets success?

mysql> create database 3208e1c6aa32;
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 '3208e1c6aa32' at line 1

mysql> create database 208e1c6aa32;
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 '208e1c6aa32' at line 1

mysql> create database 08e1c6aa32;
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 '08e1c6aa32' at line 1

mysql> create database 8e1c6aa32;
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 '8e1c6aa32' at line 1

mysql> create database e1c6aa32;
Query OK, 1 row affected (0.01 sec)

mysql> select version();
+------------+
| version()  |
+------------+
| 5.5.16-log |
+------------+
1 row in set (0.00 sec)



Thanks a lot!
Thread
help with mysql db namesDoug19 Apr
  • Re: help with mysql db namesKeith Keller19 Apr
  • Re: help with mysql db namesKapil Karekar19 Apr
    • Re: help with mysql db namesCarsten Pedersen19 Apr