# :'( MYsql version problem

**URL:** <https://forum.kirupa.com/t/mysql-version-problem/105864>\
**Category:** Uncategorized\
**Created:** [March 30, 2004, 2:46pm UTC](https://forum.kirupa.com/t/mysql-version-problem/105864 "2004-03-30T14:46:59Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![jmayo86](https://avatars.discourse-cdn.com/v4/letter/j/94ad74/32.png) [@jmayo86](https://forum.kirupa.com/u/jmayo86)\
**Post date:** [March 30, 2004, 2:46pm UTC](https://forum.kirupa.com/t/mysql-version-problem/105864/1 "2004-03-30T14:46:59Z")

</div>

Ok! i keep posting this kind of question lol but i dont get any replies!!! ok well i have done the tutorial featured @ [http://www.kirupa.com/developer/actionscript/authentication.htm](http://www.kirupa.com/developer/actionscript/authentication.htm) and i cant test it out because the SQL query wont work!

I asked around and found out that the SQL query featured on this page will not work on the version of SQL i have!

I have no knowledge of SQL and wondered if someone could help me out by changing the query featured on the page to the version of SQL i have. the version i have is MYsql 4.0.18-standard. The query featured on the page is:

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

If you are wondering what the error is whati get when i run the query its:

#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

Please help :ne:

Jay