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

Can we rollback in sql

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

Rollback in sql

ROLLBACK;		-- instead of commit

Rollback to in sql

• ROLLBACK TO name —> rolls back changes to savepoint

Similar codes

8 votes360 views5 answers
Grant permission in postgres
SQL
0 vote390 views2 answers
How to truncate all table in mysql workbench
SQL
4 votes349 views3 answers
Order by value mysql
SQL
12 votes355 views4 answers
How to take database dump in postgresql
SQL
0 vote319 views1 answer
Clone table structure mysql
SQL
3 votes435 views2 answers
Oracle drop sequence
SQL
0 vote353 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
0 vote366 views1 answer
BigQuery Remove Duplicate Keys From Table
SQL
0 vote337 views1 answer
Get last updated row sql server
SQL
0 vote333 views1 answer
SQL Server modify_timestamp trigger
SQL