# Freddies Create mySQL Table Script

**URL:** https://forum.kirupa.com/t/freddies-create-mysql-table-script/116230
**Category:** Uncategorized
**Created:** [July 15, 2004, 7:11pm UTC](https://forum.kirupa.com/t/freddies-create-mysql-table-script/116230 "2004-07-15T19:11:59Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![The\_Vulcan](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/the_vulcan/32/145_2.png) [@The\_Vulcan](https://forum.kirupa.com/u/The_Vulcan)
#### Post date: [July 15, 2004, 7:11pm UTC](https://forum.kirupa.com/t/freddies-create-mysql-table-script/116230/1 "2004-07-15T19:11:59Z")

</div>

I was trying to use the Freddy tute but get a error message with PHP admin 2.5.3

> 

CREATE TABLE auth (  
userid  
int(4)  
unsigned  
zerofill  
DEFAULT ‘0000’  
NOT NULL  
auto\_increment,  
username varchar(20),  
userpassword varchar(20),  
PRIMARY KEY (userid)  
);

**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 near ‘( 4 ) unsignedzerofillDEFAULT ‘0000’ NOT NULL AUTO\_INCREMENT ,username varc’ at line 1

Can anyone see whats wrong with the table creation script ?