在phpmyadmin中制作重复的条目

Question

I want to make a table in php my admin where I can add in duplicate data into a column so I'd have Event ID and Band ID column and it'd be like (1,3), (1,5) (2,4) So I can have more than one band relate to one event. My two tables look like this:

Band_ID and Event_ID should be a composite primary key in the second table. How do I do this in PHPMyAdmin?

Answer 1

I edited your question to reflect your clarifications shown above. The new question is "how do I create a composite key in PhpMyAdmin?" (A composite key is when two columns make up a primary key. You asked "how do I make both Event ID and Band ID a unique key combination?")

To do this in PhpMyAdmin, go into the structure of the table, and select both columns at once. Then click the "key" icon below it, as shown: