On 16 May 2003 at 19:39, Obantec Support wrote:
is it best to use 1 table x n columns(name,email,... etc, Q1,Q2,Q3...)
with a primary key or have multiple tables Table1 (name,email,....
etc) Table2 (Q1 to Q10) etc. not sure how to link the latter together.
It's hard to know with just that information, but you might consider
having one table with name, email, etc., which has an autoincrement
ID, and then another table with all the answers, with one record for
each question for each person (containing the ID from the other
table, the question number, and the answer). That way you wouldn't
have to add or subtract columns when the number of questions changes.
4 messages in com.mysql.lists.mysqlRe: table size
