Im trying to make a database of members to use with php, its very simple, just a ton of datafields per member. I try to create the database, and i get this error message, could anyone lend a hand?
mysql> CREATE TABLE members (
-> id INT NOT NULL AUTO INCREMENT,
-> username varchar(20),
-> password varchar(20),
-> email varchar(50),
-> first varchar(20),
-> last varchar(20),
-> alt1 varchar(30),
-> alt2 varchar(30),
-> alt3 varchar(30),
-> race varchar(20),
-> class varchar(20),
-> gender varchar(10),
-> level varchar(3),
-> deity varchar(30),
-> head varchar(50),
-> neck varchar(50),
-> back varchar(50),
-> chest varchar(50),
-> arms varchar(50),
-> legs varchar(50),
-> face varchar(50),
-> waist varchar(50),
-> hands varchar(50),
-> ear1 varchar(50),
-> ear2 varchar(50),
-> shoulders varchar(50),
-> wrist1 varchar(50),
-> wrist2 varchar(50),
-> finger1 varchar(50),
-> finger2 varchar(50),
-> range varchar(50),
-> melee1 varchar(50),
-> melee2 varchar(50),
-> feet varchar(50),
-> ammo varchar(50),
-> str varchar(10),
-> sta varchar(10),
-> agi varchar(10),
-> dex varchar(10),
-> wis varchar(10),
-> int varchar(10),
-> cha varchar(10),
-> attack varchar(10),
-> hp varchar(10),
-> mana varchar(10),
-> pr varchar(10),
-> mr varchar(10),
-> dr varchar(10),
-> fr varchar(10),
-> cr varchar(10),
-> lastupdate varchar(30),
-> imageid varchar(5),
-> comments TEST,
-> PRIMARY KEY(id) );
ERROR 1064: You have an error in your SQL syntax near 'AUTO INCREMENT,
username varchar(20),
password varchar(20),
email varchar(50),
f' at line 2
Thanks!
