List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 14 2001 8:34pm
Subject:Re: creating tables using a number THIS IS A BUG
View as plain text  
At 11:17 AM -0700 9/14/01, Igbar Foosenhopper wrote:
>FYI ..
>
>I just tried this my self with
>
>CREATE TABLE 010823 (tstamp TIMESTAMP (14)  ,
>        name VARCHAR (10)  not null  , PRIMARY KEY (tstamp), INDEX (name))
>
>        and got ...
>
>MySQL said: You have an error in your SQL syntax near '010823 
>(tstamp TIMESTAMP (14) , name VARCHAR (10) not null , PRIMARY KEY 
>(tst' at line 1
>
>
>The manual specificaly states in section 7.1.5  ...
>
>Table  Any character that is allowed in a file name, except `/' or `.'.
>
>SO this does seem like a bug .. hope MySql guys see this.  I have
>looked but can't find anything about how to contact in case of bugs ..


If you had read two more paragraphs, you would see:

>Note that if the identifier is a restricted word or contains special
>characters you must always quote it with ` when you use it:
>
>SELECT * from `select` where `select`.id > 100;



-- 
Paul DuBois, paul@stripped
Thread
creating tables using a numberpowlow14 Sep
  • Re: creating tables using a numberBill TQO Adams14 Sep
  • Re: creating tables using a numberPaul DuBois14 Sep
  • Re: creating tables using a number THIS IS A BUGIgbar Foosenhopper14 Sep
    • Re: creating tables using a number THIS IS A BUGPaul DuBois14 Sep
  • Re: creating tables using a number THIS IS A BUGindrek siitan14 Sep
    • Re: creating tables using a number THIS IS A BUGMatt Wagner15 Sep
  • Re: creating tables using a numberAndreas Karl Wittwer14 Sep