Alex Rivera | Logout

How to store a one to many relation in MySQL database?

Asked 2012-09-13T08:36:20.497
17

I'm making a website and I need to store a random number of data in my database.

For example, User john may have one phone number where jack can have 3.

I need to be able to store an infinite number of values per user.

Edit
Report

1 Answer

0

I think you need to create a one to many relationship table.

You can see more infos here: http://dev.mysql.com/doc/workbench/en/wb-relationship-tools.html

answered 2012-09-13T08:45:22.513

Your Answer