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 ..
Friday, September 14, 2001, 10:39:35 AM, you wrote:
p> Hi,
p> first posting to the list so hello. My name is Paulo. I live and work in
p> lisbon, portugal.
p> question : i want to create a table each month. want to call it somehting
p> like 012001 for January 2001. mysql does not seem to allow this. Jan2001 is
p> fine. d122001 is also fine. is it not possible to create tables with only a
p> number as the name? is there a way round this?
--
Best regards,
Igbar mailto:[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