The original problem is because MySql dosen't support "deferrable constraint". I "solve" this problem with this workaround: UPDATE Prova SET Prog=Prog*-1 WHERE Gruppo=16 AND Prog>=1; UPDATE Prova SET Prog=ABS(Prog)+1 WHERE Gruppo=16 AND ABS(Prog)>=1;
> Use ORDER BY clause in UPDATE statement: > http://www.mysql.com/doc/en/UPDATE.html UPDATE Prog SET Prog=Prog+1 WHERE Gruppo=16 AND Prog>=1 ORDER BY Prog DESC; I know ORDER BY usage in UPDATE but it doesn't work! > ORDER BY is supported from v4.0.0. I'm using PhP 4.0.12-nt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]