Search
 
SCRIPT & CODE EXAMPLE
 

SQL

mysql undo delete

start transaction;

savepoint sp1;

delete from customer where ID=1;

savepoint sp2;

delete from customer where ID=2;

rollback to sp2;

rollback to sp1;
Comment

PREVIOUS NEXT
Code Example
Sql :: What is SQL data store? 
Sql :: mysql sleep connections 
Sql :: oracle drop program 
Sql :: sql select maximum column with other columns returned 
Sql :: Kill session in SQL Developer 
Sql :: sql order by 
Sql :: sql round datetime 
Sql :: get last inserted primary key 
Sql :: select into oracle 
Sql :: how use trigger in sql 
Sql :: mysql date comparison with formatting 
Sql :: postgresql install with ansible 
Sql :: sqlalchemy query join many to many 
Sql :: sql select without column name 
Sql :: what is 1=2 in sql 
Sql :: mysql current date between two dates 
Sql :: mysql insert into multiple tables 
Sql :: store date time in mysql 
Sql :: compare if is null sql 
Sql :: sql server port 1434 
Sql :: sql check if column exists 
Sql :: lumen 
Sql :: 18446744073709551615 mariadb left join order by 
Sql :: SQL Comments With Statements 
Sql :: install sql 
Sql :: oracle sql winter time change 
Sql :: hashpass 
Sql :: mysql update column with value from another table 
Sql :: creating a simple notify in postgresql 
Sql :: no customers ordered 
ADD CONTENT
Topic
Content
Source link
Name
4+9 =