Savepoint in sql

• SAVEPOINT name —> marks a save point
• COMMIT —> making all pending changes permanent;
• ROLLBACK —> discharges all pending changes to prev commit
• ROLLBACK TO name —> rolls back changes to savepoint

Savepoint in sql

/* creates a temporary memory to store values which you want 
to conditionally cancel */

Similar codes

0 vote336 views1 answer
How to open mysql in docker
SQL
1 vote338 views2 answers
Oracle 18c xe ORA-65096
SQL
0 vote317 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
0 vote348 views1 answer
Postgresql using reserved word as column name
SQL
0 vote366 views1 answer
Show all sequences postgres
SQL
0 vote341 views1 answer
Make a socket server to detect changes in mysql
SQL
0 vote336 views1 answer
Sql bild in function
SQL
0 vote339 views1 answer
Synapse sql table set pk
SQL
0 vote317 views1 answer
AddEntityFrameworkSqlite
SQL
2 votes337 views1 answer
Get first n letter of department name in sql
SQL