[Solved] Where is the error in this sql statement?

by


Just Add KEY in PRIMARY like PRIMARY KEY, you have missed the SQL syntax.

CREATE TABLE users 
       (id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
        firstname VARCHAR(30) NOT NULL,
        lastname VARCHAR(30) NOT NULL,
        email VARCHAR(30) NOT NULL);

solved Where is the error in this sql statement?