can anyone tell me whats wrong with the sql query below? I saved it from other databases i’ve made with phpmyadmin and has worked in the passed great. But could an upgrade to phpmyadmin have made this incorrect?? it says invalid default for id
CREATE TABLE users ( id tinyint(4) DEFAULT ‘0’ NOT NULL AUTO_INCREMENT, name varchar(20), username varchar(20), email varchar(255), password varchar(50), PRIMARY KEY (id), UNIQUE id (id));INSERT INTO users VALUES (1,‘Mat Bryant’,‘Emerge’,‘pbrollwitme@yahoo.com’,‘word’ );
