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?