1 Reply Latest reply on Apr 3, 2004 6:05 AM by Alexey Loubyansky

    Wrong SQL Statement... (MySQL)

    Joost Newbie

      Hi folks!

      I thought I get, those UNKNOWN-PKs running, but now MySQL screams. There's a wrong statement created...

      CREATE TABLE EMPLOYEE
       (firstname VARCHAR(250),
       lastname VARCHAR(250),
       employeeid INTEGER(11) NOT NULL IDENTITY,
       CONSTRAINT PK_EMPLOYEE PRIMARY KEY (employeeid))

      Does anyone know, what the error may be, or how it can be solved?
      I think it's not okay for MySQL to put CONSTRAINT into a 'normal' CREATE Statement, but am not quite sure with that...

      Thanks a lot,
      Karsten