---
title: "What is the usage of SAVEPOINTS?"  
description: "What is the usage of SAVEPOINTS?"  
author: "Sumit Kesarwani"  
published: 2014-01-31  
updated: 2020-09-24  
canonical: https://www.mindstick.com/interview/1907/what-is-the-usage-of-savepoints  
category: "mysql"  
tags: ["mysql"]  
reading_time: 1 minute  

---

# What is the usage of SAVEPOINTS?

SAVEPOINTS are used to subdivide a transaction into smaller parts. It enables rolling back part of a transaction. Maximum of five save points are allowed.

## Answers

### Answer by Sumit Kesarwani

SAVEPOINTS are used to subdivide a transaction into smaller parts. It enables rolling back part of a transaction. Maximum of five save points are allowed.


---

Original Source: https://www.mindstick.com/interview/1907/what-is-the-usage-of-savepoints

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.