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.


Sponsored



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,