Have you considered using the SET datatype? It would be perfect for your
situation.
----- Original Message -----
From: "Nino Skilj" <[EMAIL PROTECTED]>
To: "'Tbone'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, February 23, 2001 7:38 PM
Subject: RE: Table Design -- which is better?
> The data would be 1's and 0's (on/off)
>
> Nino
>
> -----Original Message-----
> From: Tbone [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 23, 2001 4:18 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Table Design -- which is better?
>
>
> Hi,
> How would the data look a like.
> And how about the query's
>
> Greetz Tbone
> ----- Original Message -----
> From: "Nino Skilj" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Saturday, February 24, 2001 12:17 AM
> Subject: Table Design -- which is better?
>
>
> > I have a general design question.
> >
> > Is it better to design one table with 45 columns or to split it into 3
> > tables with 15 columns each. There would be about 5000 rows in the table
> and
> > it would be used more for reading rather than writing.
> >
> > I'm new to this, is there anything I'm missing?
> >
> > Thanks,
> > Nino
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php