Skip to content

Instantly share code, notes, and snippets.

@patriciovergaratobar

patriciovergaratobar/sql

Created May 29, 2018 16:47
Show Gist options
  • Save patriciovergaratobar/c9799701a322f3aee5ab1093144a4fde to your computer and use it in GitHub Desktop.
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