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

0 vote225 views1 answer
Sql show table name in result
SQL
0 vote227 views1 answer
Mysql search like but first exact match
SQL
0 vote242 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
0 vote202 views1 answer
Dump only schema
SQL
0 vote244 views1 answer
Sql sort ages
SQL
0 vote221 views3 answers
Osx stop mysql service
SQL
0 vote217 views1 answer
Get number of tables in database sql
SQL
0 vote212 views1 answer
Mysql use password error
SQL
0 vote205 views1 answer
Multiple left join mysql
SQL
0 vote212 views1 answer
Mssql view column data type
SQL