stormwild/disable_foreign_key_checks

Created May 7, 2013 02:11

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

Select an option

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

Download ZIP

Temporarily disable foreign key checks on MySQL

Raw

disable_foreign_key_checks

	SET foreign_key_checks = 0;
	DELETE FROM users where id > 45;
	SET foreign_key_checks = 1;

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