Is there anything wrong with my create table statement?

Databases
1

Hi guys,
I have an sql query which mysql is giving error:

CREATE TABLE '42011-10-04 08:10:37'(`id` INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(`id`),`url_string` VARCHAR(100),`loadtime` float(10),`comment` VARCHAR(160),`urlflag` INT NOT NULL DEFAULT '0')

Is there anything wrong with query, its giving the error as below:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near ''
42011-10-04 08:10:37'(`id` INT NOT NULL AUTO_INCREMENT,PRIMARY KEY(`id`),`url_'
at line 1

Please help.

Regards,
Ramki

2

This is not a valid table name:

‘42011-10-04 08:10:37’

3

thanks guido2004. But i need to create a table with year-mm-dd h:m:s format. How can i do this?

Thanks,
RAmki

4

You could get rid of the spaces and special signs, something like

TABLE20111004081037

5

Guido2004,
I need to include with 42011-10-04 08:10:37 this format. How can i do it? I included something say as back tic as 42011-10-04 08:10:37 but didn’t work. Is there any other way?

6

could you explain ~why~ your table name has to have that particular format?

also, i’m guessing that this isn’t going to be the only table that you will want to create with a timestamp for a name

i think you might want to reconsider your design