# Freddies Create mySQL Table Script

**URL:** <https://forum.kirupa.com/t/freddies-create-mysql-table-script/57735>\
**Category:** programming\
**Created:** [July 15, 2004, 7:11pm UTC](https://forum.kirupa.com/t/freddies-create-mysql-table-script/57735 "2004-07-15T19:11:59Z")\
**Posts on this page:** 5\
**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/57735/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 ?

---

<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:** [July 16, 2004, 5:01am UTC](https://forum.kirupa.com/t/freddies-create-mysql-table-script/57735/2 "2004-07-16T05:01:07Z")

</div>

try this. meaning copy and paste 🙂

```auto

 CREATE TABLE auth (
   userid int(4) unsigned zerofill NOT NULL auto_increment,
   username varchar(20) default NULL,
   userpassword varchar(20) default NULL,
   PRIMARY KEY (userid)
 ) TYPE=MyISAM;
 
 

```

---

<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:** [July 16, 2004, 5:20am UTC](https://forum.kirupa.com/t/freddies-create-mysql-table-script/57735/3 "2004-07-16T05:20:27Z")

</div>

Hey thanks for that **ol4pr0** worked a treat…

I have read mySQL stuff and made my own tables manually from DOS etc. but I still need a book infront of me to read commands/syntax from and can’t see errors cause I dont know it well enough.

Anyway everything makes sense to me except  
TYPE=MyISAM;

I haven’t seen that before, care to comment on what that is ?

And thanks again 🙂

---

<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:** [July 16, 2004, 5:29am UTC](https://forum.kirupa.com/t/freddies-create-mysql-table-script/57735/4 "2004-07-16T05:29:48Z")

</div>

MyISAM is the table type. This determines bits and pieces about how the table is structured in the database and so on

However it would of worked witout the MyISAME aswell 🙂

---

<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:** [July 16, 2004, 5:34am UTC](https://forum.kirupa.com/t/freddies-create-mysql-table-script/57735/5 "2004-07-16T05:34:34Z")

</div>

Sweet… will no doubt come accross it again as I learn more… 🙂