Skip to content

Instantly share code, notes, and snippets.

@alexdets

alexdets/update_user_emails_to_test.sql

Created August 12, 2015 05:15
Show Gist options
  • Save alexdets/6e6a6339fc6142048f45 to your computer and use it in GitHub Desktop.
Save alexdets/6e6a6339fc6142048f45 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
update_user_emails_to_test.sql
-- All emails will be changed to test+userid13@domain.com
UPDATE users SET email = concat('test+userid', id ,'@domain.com');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment