# SQL error

**URL:** <https://forum.kirupa.com/t/sql-error/170704>\
**Category:** programming\
**Created:** [November 28, 2005, 11:49pm UTC](https://forum.kirupa.com/t/sql-error/170704 "2005-11-28T23:49:56Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![pbrollwitme](https://avatars.discourse-cdn.com/v4/letter/p/439d5e/32.png) [@pbrollwitme](https://forum.kirupa.com/u/pbrollwitme)\
**Post date:** [November 28, 2005, 11:49pm UTC](https://forum.kirupa.com/t/sql-error/170704/1 "2005-11-28T23:49:56Z")

</div>

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