SQL question

programming
1

In the Flash/PHP/MySQL tutorial by freddythunder…

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


 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?

2

check the spaces

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

unsignedzerofillDEFAULT ?

3

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

4

post your changed query here …

5

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

userid int(4) zerofill DEFAULT ‘0000’ NOT NULL AUTO_INCREMENT,

6

Thanks Marble :slight_smile: