Skip to content

transaction_example.md

Latest commit

 

History

History
31 lines (17 loc) · 878 Bytes

transaction_example.md

File metadata and controls

31 lines (17 loc) · 878 Bytes

Session 1 :

use new_world; begin; SELECT city.name, country.name FROM country LEFT JOIN city ON city.CountryCode = country.code WHERE country.name LIKE "Netherlands";

Session 2 :

use new_world; begin; SELECT city.name, country.name FROM country LEFT JOIN city ON city.CountryCode = country.code WHERE country.name LIKE "Netherlands";

Session 1 :

delete from city where countrycode = 'NLD';

SELECT city.name, country.name FROM country LEFT JOIN city ON city.CountryCode = country.code WHERE country.name LIKE "Netherlands";

Session 2 :

SELECT city.name, country.name FROM country LEFT JOIN city ON city.CountryCode = country.code WHERE country.name LIKE "Netherlands";

rollback;

SELECT city.name, country.name FROM country LEFT JOIN city ON city.CountryCode = country.code WHERE country.name LIKE "Netherlands";

Session 1 :

/* rollback / commit */