Question
bignewbieuser on Mon, 05 May 2014 03:37:40
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 dont know whats wrong with the table i created.
Replies
Vishal Gajjar on Mon, 05 May 2014 03:57:57
Hi,
This is a forum for MS SQL Server. You should ask this question on a MySQL forum to get better answer to your question.
I haven't worked with MySQL, but I think SMALLINT does not need length to be specified. Try using below:
'Type' SMALLINT DEFAULT NULL,