Skip to content

Instantly share code, notes, and snippets.

@mrroot5

mrroot5/mysql_update_field_by_date.sql

Last active November 17, 2015 09:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mrroot5/316c4b3b3aae204ac4ec to your computer and use it in GitHub Desktop.
Save mrroot5/316c4b3b3aae204ac4ec to your computer and use it in GitHub Desktop.
Download ZIP
Actualizar un campo en base a una fecha.
Raw
mysql_update_field_by_date.sql
UPDATE `tabla` SET `campo_actualizar` = 0 WHERE `campo_fecha` < NOW() AND `campo_fecha` != '0000-00-00 00:00:00' AND `campo_fecha` IS NOT NULL
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment