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

1 vote337 views1 answer
Postgresql not in
SQL
0 vote267 views1 answer
Sqlalchemy existing database
SQL
23 votes336 views2 answers
Query to delete a database in mysql
SQL
0 vote303 views1 answer
Show function mysql
SQL
1 vote333 views1 answer
Drop function
SQL
0 vote321 views1 answer
Login failed for login due to trigger execution
SQL
8 votes337 views1 answer
Today minus 15 days postgresql
SQL
2 votes333 views1 answer
Codeigniter print last sql query
SQL
6 votes328 views2 answers
Where clause in sql
SQL
2 votes352 views1 answer
Q operator in oracle
SQL