source include/have_innodb.inc; CREATE TABLE `toto` ( `id` tinyint(4) UNSIGNED NOT NULL AUTO_INCREMENT, `Champ1` int(11) DEFAULT NULL, `Champ2` char(50) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `zero` (`id`), UNIQUE KEY `id` (`id`), KEY `Deux` (`Champ2`) ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=latin1; set autocommit=0; delete from toto where id =4444; insert into toto (id,champ1,champ2) values(null,5,'xxx'); connect (addconroot,localhost,root,,); connection addconroot; insert into toto (id,champ1,champ2) values(null,8,'yyyyy');