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

0 vote278 views1 answer
Sqlalchemy get ids
SQL
1 vote295 views1 answer
Sql server read uncommitted
SQL
1 vote276 views1 answer
Oracle sql average
SQL
2 votes275 views2 answers
How to view created temporary tables in mysql
SQL
0 vote268 views1 answer
Sql server udf performance
SQL
9 votes284 views2 answers
Sql limit to 5 results
SQL
0 vote278 views1 answer
Mysql database hyphen
SQL
1 vote276 views1 answer
Oracle sql create view
SQL
0 vote277 views1 answer
Mysql disable query caching
SQL
25 votes316 views1 answer
How to update an attribute in MySQL
SQL