Re: help with mysql db names

2013-04-19 Thread Carsten Pedersen
On 19.04.2013 06:49, Kapil Karekar wrote: 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 :-) .

help with mysql db names

2013-04-18 Thread Doug
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> cre

Re: help with mysql db names

2013-04-18 Thread Keith Keller
On 2013-04-19, Doug wrote: > > why these db names created fail but the last one gets success? [snips] > mysql> create database 3208e1c6aa32; > mysql> create database 208e1c6aa32; > mysql> create database 08e1c6aa32; > mysql> create database 8e1c6aa32; > mysql> create database e1c6aa32; https://

Re: help with mysql db names

2013-04-18 Thread Kapil Karekar
On 19-Apr-2013, at 9:14 AM, Doug 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