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

creating tables using a number

2001-09-14 Thread powlow
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 fine. d122001 is also fine. is it not possible to c