douhuang5623 2014-02-20 16:42
浏览 44
已采纳

在phpmyadmin中制作重复的条目

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:

enter image description here

enter image description here

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

  • 写回答

1条回答 默认 最新

  • douhe5092 2014-02-20 19:30
    关注

    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: enter image description here

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?