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, [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
