mysql数据表中错误1064,mySQL表错误1064

CREATE TABLE 'geodata' (

'Id' char(16) NOT NULL,

'Type' smallint(6) DEFAULT NULL,

'Description' varchar(200) DEFAULT NULL,

'Url' varchar(400) DEFAULT NULL,

'Location' point DEFAULT NULL,

PRIMARY KEY ('Id')

);

ERROR 1064:

'Id' char(16) NOT NULL,

'Type' smallint(6) DEFAULT NULL, at line1.

I don't know whats wrong with my table can someone explain?

解决方案

You should replace single quotes with back-ticks i.e `:

CREATE TABLE `geodata` (

`Id` char(16) NOT NULL,

`Type` smallint(6) DEFAULT NULL,

`Description` varchar(200) DEFAULT NULL,

`Url` varchar(400) DEFAULT NULL,

`Location` point DEFAULT NULL,

PRIMARY KEY (`Id`)

);