How do I create a concatenated primary key in phpMyAdmin using two of the rows in the same table? Do I need to just build a custom SQL query? If so, anyone care to write it?
For example:
I have a 3 column table that is acting as a composite entity for a many-to-many relationship. The first column is the primary key, the second is a foreign key from one table and the third is a foreign key from yet another table. How do I concatenate the two foreign key columns and set that value as the primary key? Keep in mind, this table isn’t static. It needs to be able to handle inserts, updates, etc.
