duplicating entries?

[sears]

Hello people,
I have a simple table as follows:
CREATE TABLE category (
id INTEGER NOT NULL AUTO_INCREMENT,
name varchar(20) NOT NULL,
PRIMARY KEY(id))

I have 10 lines of data as follows;

INSERT INTO category (Name) VALUES ('Lager');
INSERT INTO category (Name) VALUES ('Stout');
INSERT INTO category (Name) VALUES ('Bitter');
INSERT INTO category (Name) VALUES ('Other');
INSERT INTO category (Name) VALUES ('Wine');
INSERT INTO category (Name) VALUES ('Fortified Wine');
INSERT INTO category (Name) VALUES ('Spirit');
INSERT INTO category (Name) VALUES ('Cocktail');
INSERT INTO category (Name) VALUES ('AlcoPop');
INSERT INTO category (Name) VALUES ('Cider');
INSERT INTO category (Name) VALUES ('Liqueur');

Running the data in it, duplicates all the entries. Anyone have any idea why?
Thank you. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[evy]

I guess you should have a UNIQUE index on `name` if don't want duplicate entries. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --