commit in sql
COMMIT —> making all pending changes permanent;
• SAVEPOINT name —> marks a save point
• ROLLBACK —> discharges all pending changes to prev commit
• ROLLBACK TO name —> rolls back changes to savepoint
4.5
8
DELETE clause is from DML,
we can use ROLLBACK to recover the data.
• ROLLBACK —> discharges all pending changes to prev commit
• ROLLBACK TO name —> rolls back changes to savepoint
Thank you!
8
0
3.75
8
• COMMIT —> making all pending changes permanent;
• SAVEPOINT name —> marks a save point
• ROLLBACK —> discharges all pending changes to prev commit
• ROLLBACK TO name —> rolls back changes to savepoint
Thank you!
8
0
Are there any code examples left?
New code examples in category SQL