List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:October 12 1999 11:06am
Subject:Re: Can database name start with a number?
View as plain text  
On Tue, 1999-10-12 06:22:07 -0400, Bob Kline wrote:
> On Tue, 12 Oct 1999, Martin Ramsch wrote:
> 
> > On Tue, 1999-10-12 14:53:13 +0800, Jon Hui wrote:
> > > On page 102 of the mysql manual it states that a database name can
> > > start with a number. When I tried to name a database '3direct', it
> > > gave me the message 'incorrect database name '3direct''. How come?
> > 
> > You mean chapter "7.1.5 Database, table, index, column and alias
> > names" of the MySQL Reference Manual?
> > 
> > The manual seems to be wrong here for database names!
> > 
> 
> You must be running a very old version of the software, too, Martin.

No, not that old ;)
My version is 3.22.19b!

> This is from the change logs for 3.20.0:
> 
>     Changed parser to allow a database, table or field name to start
>     with a number or '_'. 

Either this has changed again later on, or this entry was just wrong
and never did apply to database names.

Maybe Monty can shed some light on this issue?

Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=5244 5EF3 B0B1 3826  E4EC 8058 7B31 3AD7
Thread
Can database name start with a number?Jon Hui12 Oct
  • Re: Can database name start with a number?Martin Ramsch12 Oct
    • Re: Can database name start with a number?Bob Kline12 Oct
      • Re: Can database name start with a number?Martin Ramsch12 Oct
        • Re: Can database name start with a number?Michael Widenius13 Oct
  • Re: Can database name start with a number?Bob Kline12 Oct