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 specifyin
rtz
Global 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
07 10:09 AM
> To: 'Jerry 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
> 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
> lin
ble at all).
Fabian
--
Fabian Köhler http://www.fabiankoehler.de
> -----Original Message-----
> From: Jerry Schwartz [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 17, 2007 3:50 PM
> To: 'Fabian Köhler'; mysql@lists.mysql.com
> Subject: RE: Max columns in a tabe
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 two tables
> 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 matc
--Original Message-
> 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 w
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
There is another question coming to my mind: is it possible to define a
view which has more columns then 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]> said:
> Fabian Köhler wrote:
> > Hello,
>
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 nece
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.
>
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
2|q1|answer3
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
2|q1|answer3
Hi,
Might be column indexing have restriction over number of columns to be
indexed, but for number of columns, hope you can overrider with the
variables
"avg_row_length" and "max_rows" during create/alter table.
The length/size of the table depends on the file system(maximum file size
defin
15 matches
Mail list logo