Skip to main content
1 of 2
newbie14
  • 979
  • 3
  • 18
  • 25

Mysql should we add extra 5 columns or build a separate table?

Currently we have a table with 35 fields in it. Now we got a requirement to add 5 extra columns but these columns will not be fill always. So I was thinking just add one column and have that id as the foreign in another table with 5 or less rows depends on the availability of data. So what is recommends to add the column or add a new table?

newbie14
  • 979
  • 3
  • 18
  • 25