SQL - How to insert records that has multiple values of the same column?
<p>I'm creating a database based on Pokemon but I'm currently stumped on inserting Pokemon with different moves. </p>

<p>Each Pokemon has a move set, so not just one move, but many. However, as I attempt to insert the Pokemon with its variable-length amount of moves into the table, MySQL ignores the previous ones and only inserts the last move. </p>

<p>In short: how do I insert multiple records of the same Pokemon but with its different move?</p>

<p>[I guess a good similar real-world example would be a Person having multiple email addresses. How would I go about inserting that into a table?]</p>