Another MYSQL question

[catgurl_ashley]

I realize this isnt a php question, but I didnt know where else to ask, thought you guys might have a sister site, looked for links but found none....oh well here goes nuthin

Im running this query and it isnt working....
im trying to make "id" Autoincrement...

its pretty much saying i have a syntax problem....anyone know whats up?

CREATE table In_charecter (
id INT PRIMARY KEY AUTOINCREMENT,
member_id INT,
name TEXT,
picture TEXT,
description TEXT,
gender TEXT,
jewelry TEXT,
footware TEXT,
gloves TEXT,
shirt TEXT,
pants TEXT,
abilities TEXT,
abilities_2 TEXT,
race TEXT,
based_on TEXT,
member_name TEXT,
piercings TEXT,
sign TEXT,
element TEXT,
stat_agility INT,
stat_intel INT,
stat_strength INT,
stat_attract INT,
stat_spirit INT,
stat_loyalty INT,
age INT,
picture_2 TEXT,
weapons TEXT,
)

[SP8600]

Here's your problem:

id INT PRIMARY KEY AUTOINCREMENT,

Change that to

id INT PRIMARY KEY AUTO_INCREMENT,

[catgurl_ashley]

lol...that figures :p THANKEE 😃