How can I use phpmyadmin to set relationships for column data across two tables?
Let's say I have a
id | userName
id | customerID | customerName
how can I tell phpmyadmin that the
customerName is always equal to the
userName based on the
customerID even if the username gets updated?
Is such a thing possible and if yes whats the relationship called?