START TRANSACTION; SELECT * FROM employes; UPDATE employes SET salaire = 123 WHERE id_employes = 699; SELECT * FROM employes; ROLLBACK; -- ou COMMIT;
START TRANSACTION
permet de démarrer une zone de requête sous réserve de confirmation / annulation.ROLLBACK;
COMMIT;
START TRANSACTION
.START TRANSACTION; SELECT * FROM employes; SAVEPOINT point1; UPDATE employes SET salaire = 1500 WHERE id_employes = 699; SELECT * FROM employes; SAVEPOINT point2; UPDATE employes SET salaire = 2300 WHERE id_employes = 699; SELECT * FROM employes; SAVEPOINT point3; UPDATE employes SET salaire = 1400 WHERE id_employes = 699; SELECT * FROM employes; SAVEPOINT point4; ROLLBACK to point3; -- retour au point3 SELECT * FROM employes; ROLLBACK to point4; -- ERREUR ROLLBACK to point1; -- retour au point1 COMMIT; -- Valide et termine la transaction.
SAVEPOINT
permet de créer un point de restauration sur lequel nous pourrons revenir plus tard.SQL
1. Base De Donnees 2. Modelisation Base De Donnees 3. Requete De Selection Select 4. Requete D'insertion Insert 5. Requete De Modification Update 6. Requete De Supression Delete 7. Exercice Requete 8. Requete Imbriquee 9. Jointure 10. Union 11. Function 12. Table Virtuelle 13. Table Temporaire 14. Transaction 15. Variable Et Requete Preparee 16. Procedure Stockee 17. Trigger 18. Event 19. Entrainement Evaluation 20. Contraintes Integrite