Rollback to in sql

Rollback in sql

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

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

Can we rollback in sql

es, since this DELETE clause is from DML,
we can use ROLLBACK to recover the data.

Rollback to in sql

• ROLLBACK TO name —> rolls back changes to savepoint

Similar codes

1 vote123 views1 answer
Error code 1175 mysql fix
SQL
0 vote123 views1 answer
Sql last 3 rows
SQL
0 vote106 views1 answer
Select password from user mysql
SQL
1 vote142 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
0 vote113 views1 answer
What is ssrs and ssis in sql server
SQL
5 votes106 views1 answer
Sql asynchronous stored procedure call
SQL
0 vote67 views1 answer
Oracle last user logon
SQL
0 vote124 views1 answer
Databricks install odbc driver connect to sql server
SQL
0 vote115 views2 answers
How to set global time_zone in mysql
SQL
3 votes112 views2 answers
How to load files in mysql
SQL