Unanswered: Most effective method of managing the data?
I have a large SQL Database im building, in the database there is a table for each user with certain things listed. One problem is, sometimes in a few collums, there will be like 100things listed, instead of one line.
Products in that some users will have 1 product like "apples" but others will have many more products.
What is the most effective way of listing the data? Create new tables? Seperate the products with comma's or spaces?
How do I do it, and keep the overall db size smaller?
You want rows, not comma sepearted values
CREATE TABLE myInterests99(UserId varchar(8), Interest varchar(25))
INSERT INTO myInterests99(UserId,Interest)
SELECT 'X002548','Skiing' UNION ALL
SELECT 'X002548','Hockey' UNION ALL
SELECT 'X002548','Tennis' UNION ALL