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

3 votes261 views3 answers
How to add month in update sql
SQL
32 votes292 views6 answers
Insert select
SQL
0 vote299 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
0 vote266 views1 answer
Sql #region
SQL
5 votes266 views1 answer
Sql check if date is between 2 dates
SQL
12 votes294 views1 answer
Run mysql instance in docker
SQL
0 vote259 views1 answer
Postgres jsonb array push new element
SQL
-1 vote255 views1 answer
Sql syntax create timestamp column
SQL
0 vote261 views1 answer
Mysql count by month
SQL
0 vote266 views1 answer
Match end of string regex sql
SQL