Is there anything wrong with my create table statement?

[ramki067]

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

[rangana]

Please use this:

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