Ir001/truncate.sql

Created June 13, 2021 07:32

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/Ir001/f12f9289edb07c952391745fb3464ac9.js"></script>
Save Ir001/f12f9289edb07c952391745fb3464ac9 to your computer and use it in GitHub Desktop.

Download ZIP

How to TRUNCATE foreign table

Raw

truncate.sql

	SET FOREIGN_KEY_CHECKS = 0;
	TRUNCATE table $table_name;
	SET FOREIGN_KEY_CHECKS = 1;

	#DWYOR

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