set autocommit = off;

START TRANSACTION; 

UPDATE PERSONNE SET nomPersonne = 'Blanca' WHERE nomPersonne = 'Elvia';

SELECT * FROM PERSONNE WHERE idPersonne = 1;

COMMIT;