[RESOLVED] Using ON DUPLICATE KEY UPDATE

[mrbaseball34]

Got this table:

CREATE TABLE `tags` (
	`tag_id` INT(11) NOT NULL AUTO_INCREMENT,
	`tag_title` VARCHAR(20) NOT NULL,
	`tag_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
	PRIMARY KEY (`tag_id`),
	INDEX `tag_title` (`tag_title`)
)
COLLATE='utf8_unicode_ci'
ENGINE=InnoDB
ROW_FORMAT=DEFAULT

Need to not insert new record with same tag_title...possible? Or do I need to do something different with the indexes?

[bradgrafelman]

Instead of just an INDEX, add a UNIQUE index on that column.

[mrbaseball34]

Perfect, Brad, thanks.