Skip to content

Instantly share code, notes, and snippets.

@smellman

smellman/ushahidi_allemail_change.sql

Created March 20, 2011 05:41
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 smellman/878124 to your computer and use it in GitHub Desktop.
Save smellman/878124 to your computer and use it in GitHub Desktop.
Download ZIP
全てのユーザのメアドを一気に変更する。
Raw
ushahidi_allemail_change.sql
update users set email = concat(concat('btm+', id), '@smellman.org');
update incident_person set person_email = concat(concat('btm+', id), '@smellman.org');
update comment set comment_email = concat(concat('btm+', id), '@smellman.org');
update alert set alert_recipient = concat(concat('btm+', id), '@smellman.org');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment