floridaflatlander Posted February 27, 2013 Share Posted February 27, 2013 I have a mysql table of items and was wondering if it would be to confusing to combine the columns used for the different “non-repeating info” that items had. Instead of having columns for the number of bathrooms, boat length, rv length and camper length have one column called something like num1. I've always heard that you should name columns in a way that associates with the column info, but if I combine columns I just have to add 18 columns, if I don't combine them I have to add 50 plus columns. Or .. even though the data is non repeating go ahead and make tables for the info for realestate, boats, autos, rv's and on and on. Just looking for some ideas Thanks Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.