At 11:17 AM -0700 9/14/01, Igbar Foosenhopper wrote:
>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