locked
mySQL database 1064 ERROR RRS feed

  • Question

  •     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.

    Monday, May 5, 2014 3:37 AM

Answers

  • 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,


    - Vishal

    SqlAndMe.com

    Monday, May 5, 2014 3:57 AM