by the OS). Try giving maximum value for avg_row_length.
Thanks
ViSolve DB Team
- Original Message -
From: Fabian Köhler [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, April 17, 2007 4:34 AM
Subject: Max columns in a tabel in MyISAM storage engine
Hello,
i have table
Fabian Köhler wrote:
Hello,
i have table with answers to questions. Every answer is a column in the table.
i.e.
id|q1|q2|q3
1|answer1|answer2|answer5
2|answer3|answer4|asnwer6
another option to save it would be sth like this:
id|field|value
1|q1|answer1
1|q2|answer2
1|q3|answer5
Fabian Köhler wrote:
Hello,
i have table with answers to questions. Every answer is a column in the table.
i.e.
id|q1|q2|q3
1|answer1|answer2|answer5
2|answer3|answer4|asnwer6
another option to save it would be sth like this:
id|field|value
1|q1|answer1
1|q2|answer2
1|q3|answer5
Thanks for all the input. The problem i have with this idea:
Really? Wow, my opinion is that you're trying to do in one table what
you should do in two. Have a questions table, and an answers table. The
answers table would have a column specifying which question they belong
to. i.e.
I also thought about creating a materialized view with mysql by doing:
create table vanswers (select ... query to get the table in the
format..)
or a stored procedure which generates a table like the one below, but
all solutions seem to be slow like hell due to the high large joins
which are
There is another question coming to my mind: is it possible to define a
view which has more columns then put nof cols limit for storage engine
here or does the same limits for a normal table apply to a view?
regards,
Fabian
On Mon, 16 Apr 2007 23:39:40 -0700, Micah Stevens
[EMAIL PROTECTED]
Hi,
Really? Wow, my opinion is that you're trying to do in one table what
you should do in two. Have a questions table, and an answers table. The
answers table would have a column specifying which question they belong
to. i.e.
QUESTIONS
int autoincrement questionID
question
ANSWERS
int
Schwartz'
Cc: 'mysql@lists.mysql.com'
Subject: RE: Max columns in a tabel in MyISAM storage engine
The right way to do this would be your second way, where
there would be
one row per answer. I can't really grasp how the questions
and answers
relate to anything else, so I'm making a lot
Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Martijn Tonies [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 17, 2007 10:13 AM
To: mysql@lists.mysql.com
Subject: Re: Max columns in a tabel in MyISAM storage engine
The right way to do this would be your second way, where there would be
one row per answer. I can't really grasp how the questions and answers
relate to anything else, so I'm making a lot of assumptions.
If you are concerned that this technique is too slow, because it involves
linking
Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Fabian Köhler [mailto:[EMAIL PROTECTED]
Sent: Monday, April 16, 2007 7:04 PM
To: 'mysql@lists.mysql.com'
Subject: Max columns in a tabel in MyISAM storage engine
Hello,
i
Not necessarily. I do precisely this for a data base whose structure I do
not control. I stuff
|code1|code2|code3| ...
Into an unused text field. The users can query on LIKE %|code2|%. The key
is to have a delimiter at the start and end of the entire list, so that
the
string match
-
From: Martijn Tonies [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 17, 2007 9:53 AM
To: mysql@lists.mysql.com
Subject: Re: Max columns in a tabel in MyISAM storage engine
The right way to do this would be your second way, where
there would be
one row per answer. I can't really grasp how
'; mysql@lists.mysql.com
Subject: RE: Max columns in a tabel in MyISAM storage engine
The right way to do this would be your second way, where
there would be
one row per answer. I can't really grasp how the questions and answers
relate to anything else, so I'm making a lot of assumptions
On 04/17/2007 04:18 AM, Fabian Köhler wrote:
Thanks for all the input. The problem i have with this idea:
Really? Wow, my opinion is that you're trying to do in one table what
you should do in two. Have a questions table, and an answers table. The
answers table would have a column
Hello,
i have table with answers to questions. Every answer is a column in the table.
i.e.
id|q1|q2|q3
1|answer1|answer2|answer5
2|answer3|answer4|asnwer6
another option to save it would be sth like this:
id|field|value
1|q1|answer1
1|q2|answer2
1|q3|answer5
2|q1|answer3
...
The last one is
16 matches
Mail list logo