# SQL question

**URL:** <https://forum.kirupa.com/t/sql-question/65519>\
**Category:** programming\
**Created:** [September 27, 2004, 10:43am UTC](https://forum.kirupa.com/t/sql-question/65519 "2004-09-27T10:43:15Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![macneilslt](https://avatars.discourse-cdn.com/v4/letter/m/aeb1de/32.png) [@macneilslt](https://forum.kirupa.com/u/macneilslt)\
**Post date:** [September 27, 2004, 10:43am UTC](https://forum.kirupa.com/t/sql-question/65519/1 "2004-09-27T10:43:15Z")

</div>

In the Flash/PHP/MySQL tutorial by freddythunder…

> **[kirupa.com - Login Using Flash MX, PHP, and MySQL](https://www.kirupa.com/developer/actionscript/authentication.htm)**
>
> Create an authentication form using Flash, PHP, and mySQL.

I have a problem, In the third section, the MySQL section, when I try to use the code…

```auto

 CREATE TABLE auth (
  userid
    int(4)
    unsigned
    zerofill
    DEFAULT '0000'
    NOT NULL
    auto_increment,
  username varchar(20),
  userpassword varchar(20),
  PRIMARY KEY (userid)
);

```

When i use that, i get an error like this:

> 

Database fallout\_login running on localhost

Error

SQL-query :

CREATE TABLE auth(  
useridint( 4 ) unsignedzerofillDEFAULT ‘0000’ NOT NULL AUTO\_INCREMENT ,  
username varchar( 20 ) ,  
userpassword varchar( 20 ) ,  
PRIMARY KEY ( userid )  
)

MySQL said:  
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '( 4 ) unsignedzerofillDEFAULT ‘0000’ NOT NULL AUTO\_INCREMEN

What am I doing wrong?

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [September 27, 2004, 11:09am UTC](https://forum.kirupa.com/t/sql-question/65519/2 "2004-09-27T11:09:18Z")

</div>

check the spaces

CREATE TABLE auth(  
useridint( 4 ) unsignedzerofillDEFAULT ‘0000’ NOT NULL AUTO\_INCREMENT ,  
username varchar( 20 ) ,  
userpassword varchar( 20 ) ,  
PRIMARY KEY ( userid )  
)

unsignedzerofillDEFAULT ?

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [September 27, 2004, 2:35pm UTC](https://forum.kirupa.com/t/sql-question/65519/3 "2004-09-27T14:35:34Z")

</div>

thanks for the reply, but i still seem to get the same error… :-/

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [September 28, 2004, 4:56am UTC](https://forum.kirupa.com/t/sql-question/65519/4 "2004-09-28T04:56:46Z")

</div>

post your changed query here …

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [September 28, 2004, 5:30am UTC](https://forum.kirupa.com/t/sql-question/65519/5 "2004-09-28T05:30:04Z")

</div>

mySQL automatically assigns “unsigned” to a zerofill field. and your spacing is off:

userid int(4) zerofill DEFAULT ‘0000’ NOT NULL AUTO\_INCREMENT,

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [September 28, 2004, 7:59pm UTC](https://forum.kirupa.com/t/sql-question/65519/6 "2004-09-28T19:59:00Z")

</div>

Thanks Marble 🙂