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?