Skip to main content
Database Administrators

Return to Question

Tweeted twitter.com/#!/StackDBAs/status/214486330078539776
Removed 'mysql' tag since there is nothing mysql-specific mentioned. I added the database-design tag in its place.
Source Link
RolandoMySQLDBA
RolandoMySQLDBA
  • 184.3k
  • 33
  • 323
  • 531

Mysql should 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

Which is recommends to add the column or add a new table?better

  • add the column ?
  • add a new table ?

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?

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.

Which is better

  • add the column ?
  • add a new table ?
Source Link
newbie14
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?