Reconnecting Usernames and Passwords

You may be submitting names which are part of a membership database and wish to reconnect the username and password to that membership record after they have been created. To do this:

1. Submit the names with the unique membership number prepended to the start of each name as shown in the example.
2. Once the usernames and passwords have been created, save the output to a text file.
3. Import that text file into a temporary database table in the same database as the one which contains your membership records. Name this table, “loginData.”
4. Add two columns to the original database table from which the member number and name were selected. The columns should be named, “username” and “password.”
5. Execute the following SQL query (requires an understanding of how to execute SQL queries in your database).
   
   UPDATE original_membership_table
   SET username = loginData.username,
        password = loginData.password
   FROM original_membership_table INNER JOIN loginData
   ON loginData.id = original_membership_table.id

It is highly recommend that you do this first in a test environment before acting on live data.