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?
Mysql should we add extra 5 columns or build a separate table?
newbie14
- 979
- 3
- 18
- 25