+ 1
Set row name of one table to a row in a different table
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.
1 Answer
+ 3
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