RE: Time Allocation Issue
| From: | Jefferson Cowart | Date: | Mon, 29 Jul 2002 23:51:25 +0000 |
| Subject: | RE: Time Allocation Issue | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-20879@lists.php.net to get a copy of this message | ||
Thank you that did exactly what I was looking for.
----------------
Thanks
Jefferson Cowart
Jeff@cowart.net
Support Open Instant Messaging Protocols
http://www.petitiononline.com/openIM/petition.html
> -----Original Message-----
> From: Ryan Fox [mailto:rfox@amerisuk.com]
> Sent: Monday, July 29, 2002 16:08
> To: Jefferson Cowart
> Cc: mysql@lists.mysql.com
> Subject: Re: Time Allocation Issue
>
>
> > I have tried doing just a unique
> > index on referee, date, and time but the issue is I use a 0
> to indicate
> > that the slot is open.
> <snip>
> Is
> > there any better more efficient way to do this?
>
> Use null to indicate the slot is open. Your unique index can have
> multiple null values, but not multiple zero values. I believe this is
> what you are looking for.
>
> Cheers,
> Ryan Fox
> rfox@amerisuk.com
>