patriciovergaratobar/sql

Created May 29, 2018 16:47

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

Download ZIP

MySQL: Eliminar o Actualizar de forma masiva

Raw

sql

	-- Eliminar o Actualizar de forma masiva

	SET SQL_SAFE_UPDATES=0;

	UPDATE tablename SET columnname=1;

	DELETE FROM tablename;

	SET SQL_SAFE_UPDATES=1;

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