Set row name of one table to a row in a different table

Question

I have table A with username and password as rows and I have another table B with customer name as row.
I want customer to be equal to username in table A such that each time a new username is added to table A customer name in table B takes the same username.

Answer 1

Lookup for triggers, these are set of commands that you can set to be executed before or after a modification (create, update, delete) takes place for a table. Here's a good reference site covering MySQL database trigger.

http://www.mysqltutorial.org/mysql-triggers.aspx

Hth, cmiiw