+ 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.

17th Nov 2018, 8:29 AM
Ben Acq
Ben Acq - avatar
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
17th Nov 2018, 5:50 PM
Ipang