,2,23),(2000,2,23);
SELECT year,month,BIT_COUNT(BIT_OR(1<
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 14, 2003 9:17 AM
Subject: Database Design and Bianry Operations
> Hello,
>
> I'm after some advice on database design:
>
> I've got an object - for
Lee,
> I get the feeling there is a more efficient method using
> binary operations
> (only one field populated with zeros and ones) but I can't
> find anything to
> help in the manuals.
i think you should try to avoid such thing as much as you can.
Storing more than one piece of data in a colu
ant tables.
HTH
Kev.
> --
> From: Lee Denny
> Sent: Tuesday, October 14, 2003 14:17 PM
> To: [EMAIL PROTECTED]
> Subject: Database Design and Bianry Operations
>
> Hello,
>
> I'm after some advice on database design:
>
> I&#
- have
fitness club - doesn't matter
Best regards,
Mikhail.
- Original Message -
From: "Lee Denny" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 14, 2003 3:17 PM
Subject: Database Design and Bianry Operations
> Hello,
>
> I'
Hello,
I'm after some advice on database design:
I've got an object - for an example a hotel - and I want to keep information
about this hotel, criteria that it either has or hasn't (TV, swimming pool
etc).
I want to search on criteria and return the most appropriate match.
Bearing in mind I've
