What is the best way to update addresses on a database? - best database
I have 1800 names in a database for the school. I would like an alumni organization, which means they need to create update your contact information. What is the best way to do this?
Is it possible to automate the process?
Best Database What Is The Best Way To Update Addresses On A Database?
1 comments:
They seem to have to do one or two things. 1) Create a separate table in the house of the old information. 2) Create a relationship between the table and each student in the peloton. 3) Finally, update information for students depending on the status of their students.
Tbl_Students
* Students | Alumni | name, etc. | ..
Tbl_Alumni
* Alumni | Alumni Name | DESC | etc. ..
However, the updating of each student of the ancients like all the students who want to update it. Unless every student has the same feeling of power, should be treated in line by line. To change the names of alumni addresses, then just update the old table that corresponds to each student.
Standardization of databases 101
Post a Comment