Hi. In MySql I create this table:
CREATE TABLE `prova` ( `Gruppo` int(11) NOT NULL default '0', `Prog` int(11) NOT NULL default '0', `Descrizione` varchar(100) default '', PRIMARY KEY (`Gruppo`, `Prog`) ) TYPE=MyISAM; Running this: UPDATE Prog SET Prog=Prog+1 WHERE Gruppo=16 AND Prog>=1 I get "Duplicate entry". Is this a MySql bug? How can I do this? Tnx, bye. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]