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

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.