mysql problem

[God..]

search_id, INTEGER, NOT NULL, AUTO_INCREMENT, UNSIGNED
word, VARCHAR(50), NOT NULL
occurrence, INTEGER, NOT NULL, UNSIGNED
url, VARCHAR(200), NOT NULL
link, VARCHAR(200), NOT NULL


Why doesnt this work?

[Eccentric]

what are you trying to do with them, add them ?

[Jme]

CREATE TABLE `table_name` (
`search_id` INT NOT NULL AUTO_INCREMENT,
`word` VARCHAR(50) NOT NULL,
`occurrence` INT NOT NULL,
`url` VARCHAR(200) NOT NULL,
`link` VARCHAR(200) NOT NULL,
PRIMARY KEY(`search_id`)
);
That should work.