eikki
>
> -Original Message-
> From: Heikki Tuuri <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
> Date: Thursday, February 21, 2002 9:27 AM
> Subject: Re: Fake interval data type
>
> >Hi!
> >
> >>Its kind of a subtle po
Oops,
the syntax is
SELECT ... FROM ... WHERE .. LOCK IN SHARE MODE;
Heikki
-Original Message-
From: Heikki Tuuri <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Thursday, February 21, 2002 9:27 AM
Subject: Re: Fake interval data type
>Hi!
&g
Hi!
>Its kind of a subtle point, but innodb's locking not only locks rows, it
>locks the ABSENCE of rows. If I understand correctly this means that
>something like:
>
>BEGIN WORK
>SELECT COUNT(*) FROM table WHERE starttime>? AND endtime(check the count)
>INSERT INTO table (if count is zero)
On Wednesday 20 February 2002 05:51, Sasa Babic wrote:
> On Wed, Feb 20, 2002 at 11:38:31AM +0100, [EMAIL PROTECTED] wrote:
> > sql,query
>
> The above is for antispam filter.
>
>
>
> I have a need for an interval data type. It would contain start and end
> of a certain time event. Since it is not
On Wed, Feb 20, 2002 at 11:38:31AM +0100, [EMAIL PROTECTED] wrote:
>
> sql,query
The above is for antispam filter.
I have a need for an interval data type. It would contain start and end
of a certain time event. Since it is not possible to have two different
events at the same place and at th