Create Table not working with SQL Query?

[jhc1982]

Hey guys,

 

I am working through PHP & MySQL for dummies. I have gotten to the application build tutorials at the end of the book and I cannot get my tables to build with an SQL Query from phpMyAdmin.

 

i am trying to create a table called pet with 6 columns, petID, petName, petType, petDescription, price & pix.

 

I am using the following syntax

 

CREATE TABLE Pet(

petID INT(5) SERIAL,

petName VARCHAR(25) NOT NULL,

petType VARCHAR(15) NOT NULL DEFAULT "Misc",

petDesc VARCHAR(255),

price DECIMAL(9,2),

pix CHAR(15) NOT NULL DEFAULT "nopic.jpg",

PRIMARY KEY (petID)

);

 

Can anyone spot anything that I may be doing wrong? I really just cannot spot it??

 

I am using MySQL client version: 5.1.44 which I installed with XAMPP

 

[Pikachu2000]

Replace 'SERIAL' with 'AUTO_INCREMENT'