Re: creating tables using a number THIS IS A BUG

2001-09-14 Thread Matt Wagner
indrek siitan writes: > Hi, > > > 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 .. > > mail to [EMAIL PROTECTED] :-) er, [EMAIL PROTECTED] -- For technical support contracts, visit https://order.mysql

Re: creating tables using a number THIS IS A BUG

2001-09-14 Thread Paul DuBois
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 nea

Re: creating tables using a number

2001-09-14 Thread Andreas Karl Wittwer
Hello, On Fri, 14 Sep 2001, powlow wrote: > fine. d122001 is also fine. is it not possible to create tables with only a > number as the name? is there a way round this? mysql> CREATE TABLE `123` (id INT); Query OK, 0 rows affected (0.00 sec) mysql> show tables; ++ | Tabl

Re: creating tables using a number THIS IS A BUG

2001-09-14 Thread indrek siitan
Hi, > 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 .. mail to [EMAIL PROTECTED] :-) Rgds, Indrek -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/

Re: creating tables using a number THIS IS A BUG

2001-09-14 Thread Igbar Foosenhopper
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 ,

Re: creating tables using a number

2001-09-14 Thread Paul DuBois
At 6:39 PM +0100 9/14/01, powlow wrote: >Hi, > >first posting to the list so hello. My name is Paulo. I live and work in >lisbon, portugal. > >question : i want to create a table each month. want to call it somehting >like 012001 for January 2001. mysql does not seem to allow this. Jan2001 is >fin

Re: creating tables using a number

2001-09-14 Thread Adams, Bill TQO
powlow wrote: > first posting to the list so hello. My name is Paulo. I live and work in > lisbon, portugal. > > question : i want to create a table each month. want to call it somehting > like 012001 for January 2001. mysql does not seem to allow this. Jan2001 is > fine. d122001 is also fine. is