List:MySQL on Win32« Previous MessageNext Message »
From:Paul DuBois Date:December 20 2002 6:36am
Subject:Re: Numeric number table name NOT allow!
View as plain text  
At 20:09 -0800 12/19/02, How Loon wrote:
>Greetings,
>
>Why I could NOT create a table (Type: MyISAM) where
>the table name is a
>set of numeric number, for example:
>'12156' or '6454'?

Because you didn't quote it within backticks.

All-numeric names are not otherwise distinguishable
from numbers, which leads to all kinds of ambiguities.

>
>The table I created is NOT describe-able by using
>MySQL comand:
>"describe 12156;".

describe `12156`';

>I'm using MySQL ver 3.23.54 and thanks in advance.
>
>ascll
>ascll@stripped

Thread
Numeric number table name NOT allow!How Loon20 Dec
  • Re: Numeric number table name NOT allow!Paul DuBois20 Dec