Skip to content

Instantly share code, notes, and snippets.

@masonjo

masonjo/full_date_added-upate.sql

Last active June 25, 2020 19:40
Show Gist options
  • Save masonjo/841c8d30253201f2f1ce0860eb7a4815 to your computer and use it in GitHub Desktop.
Save masonjo/841c8d30253201f2f1ce0860eb7a4815 to your computer and use it in GitHub Desktop.
Download ZIP
Update full_date_added in mysql #mysql
Raw
full_date_added-upate.sql
UPDATE subscribers SET `full_date_added`=FROM_UNIXTIME(date_added) WHERE `full_date_added` IS NULL;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment