How to implement dynamic database columns?

Question

I need to store in db some info about item. I have *item_id*, *item_name*, but i don't know in advance how many info will have this item. One of the can have *item_info1* and *item_info2* , while another will have only *item_info1*. How i can realise this dynamic of the columns?. I think only about storing serialize info in a cell, but this way for getting separate *item_infoN* i must to request the full cell data. This is not comfortable way, I believe that there is another way to solve this problem. Thx!

sachleen · Accepted Answer · 2013-05-12 03:46:05Z

2

Use another table.

Items
  item_id
  item_name

Item_Infos
  item_id
  item_info
Foreign Key item_id references Items(item_id)

You can have as many item infos as you want for any item.

Resources:

answered May 12, 2013 at 3:46

sachleen

31.2k8 gold badges81 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to implement dynamic database columns?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related