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

2 votes238 views1 answer
Grant revoke privileges to mysql username
SQL
0 vote247 views1 answer
Sql missing values
SQL
0 vote230 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
11 votes265 views6 answers
Mysql else if
SQL
0 vote233 views1 answer
Replace multiple string in query sql
SQL
0 vote308 views1 answer
Split first name and last name in sql
SQL
0 vote242 views1 answer
Exclude last comma separated string mysql
SQL
0 vote259 views1 answer
Transaction and commit trong sql server
SQL
0 vote236 views1 answer
Mysql set column equal to another automatic
SQL
0 vote237 views1 answer
St_buffer mysql
SQL