Skip to content

Instantly share code, notes, and snippets.

@jmillerdesign

jmillerdesign/remove_real_emails.sql

Created April 19, 2017 06:53
Show Gist options
  • Save jmillerdesign/12340ca29a012c9f8deb097764a394f8 to your computer and use it in GitHub Desktop.
Save jmillerdesign/12340ca29a012c9f8deb097764a394f8 to your computer and use it in GitHub Desktop.
Download ZIP
Remove real email addresses from a dev database
Raw
remove_real_emails.sql
UPDATE `users` SET `email` = CONCAT('dev-', `id`, '@example.com');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment