BetterPHP

II have a table which looks like

CREATE TABLE IF NOT EXISTS `some_table`
(
	`field_one`		CHAR(6) NOT NULL,
	`field_two`			INT(1) NOT NULL,
	`field_three`	INT(4) NOT NULL,
	`field_four`		INT(10) NOT NULL
)
ENGINE = InnoDB;

and then I add constraints to it, making a row into a unique key

ALTER TABLE `some_table` ADD UNIQUE `vote` (`field_one`,`field_two`,`field_three`, `field_four`);

In order to test my setup, I am running the following query:

 INSERT INTO `some_table` (`field_one`, `field_two`, `field_three`, `field_four`) VALUES ('C8696E', 1, 1, 0) ON DUPLICATE KEY UPDATE `field_three` = `field_three` + 1

First of all it created one row and then a second row. The first row has `field_three` set to 1 and the second row has `field_three` set as 2 but when I press refresh again, I get this error #1062 - Duplicate entry 'C8696E-1-2-0' for key 'vote'

What am I doing wrong?

Worked it out now