mysql create table coding help

[Anon]

I need to create the following table which I altered. For some reason it will not create the required table..

Can anyone pls help me
Thanks
JOe

CREATE TABLE mycontent (
contentID int(3) NOT NULL auto_increment,
menutitle varchar(255) NOT NULL ,
contenttitle varchar(250) ,
logoimage text ,
bannerimage text ,
content text ,
contentnextoimage text ,
imagenexttotext ,
copyright text ,
PRIMARY KEY (contentID) ,
KEY contenttitle (contenttitle) ,
);

[[deleted]]

forgot a space here:

imagenexttotext ,

[Anon]

I have tried your method still dont work. I have tried the following still dont work.

can anyone help me pls

Joe

CREATE TABLE mycontent (
contentID int(3) NOT NULL auto_increment,
menutitle varchar(255) NOT NULL ,
contenttitle varchar(250) ,
logoimage text,
bannerimage text,
content text,
contentnextoimage text,
imagenextto text,
copyright text,
PRIMARY KEY (contentID) ,
KEY contenttitle (contenttitle) ,
);

[[deleted]]

read you query carefully, you have an extra comma at the end.

[Anon]

Hi Vincent Im new to this. Is it possible to correct and retype it for me and maybe run it just to double check it works.

Thanks For your Help

Joe

[[deleted]]

Just remove the last comma, which is clearly out of place.

[Anon]

Thanks Vincent for your help I finally worked it out by backtracking sql that worked and slowly modifying it to suit. For those wondering the following worked and was the solution.

Notice the last line which was the problem and only created the table if the last line was used identically to how I typed as per example

---

eg this worked as last line

KEY contenttitle (contenttitle))

---

If I used the following for the last line this did not create the table and did not work

eg

KEY contenttitle (contenttitle)
)

It goes to show you how padantic this can get..

Original Code below. Again thanks for your time

Joe

---

CREATE TABLE mycontent (
contentID int(3) NOT NULL auto_increment,
menutitle varchar(255) NOT NULL ,
contenttitle varchar(250) ,
logoimage text ,
bannerimage text ,
content text ,
contentnextoimage text ,
imagenexttotext ,
copyright text ,
PRIMARY KEY (contentID) ,
KEY contenttitle (contenttitle))

---