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

3 votes127 views1 answer
Sql double index
SQL
0 vote124 views1 answer
Get week day name sql server
SQL
0 vote144 views1 answer
What is common table expression in sql
SQL
2 votes134 views1 answer
Java.lang.arrayindexoutofboundsexception: index 0 out of bounds for length 0
SQL
0 vote133 views1 answer
Sp in sql server
SQL
0 vote142 views1 answer
SELECT statement to find the specific cell in database table
SQL
0 vote119 views1 answer
Access refused mysql xampp server
SQL
1 vote261 views1 answer
Postgres convert text to number
SQL
0 vote118 views1 answer
Mariadb LOAD DATA INFILE
SQL
1 vote122 views1 answer
Get rows affected mysql python
SQL