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

[ad_1]

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);

[ad_2]

solved Where is the error in this sql statement?