peisenhower/mysql-harmless.sql

Created August 31, 2017 19:22

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/peisenhower/e95a3170ff9830e4fa5ad00b98c8920b.js"></script>
Save peisenhower/e95a3170ff9830e4fa5ad00b98c8920b to your computer and use it in GitHub Desktop.

Download ZIP

mysql transaction and rollback to test database modifications

Raw

mysql-harmless.sql

	BEGIN;


	INSERT INTO teams
	(name, uuid)
	VALUES
	('inner-transaction', UNHEX(REPLACE(UUID(), '-','')));


	select * from teams;

	ROLLBACK;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment