Since I
didn't use the update_log, all data from today is gone. Live and learn.
Thanks for all your help!
-Original Message-
From: Quentin Bennett [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 5:58 PM
To: 'Daren Cotter'; [EMAIL PROTECTED]
Subject: RE: more d
entin Bennett; [EMAIL PROTECTED]
Subject: RE: more date problems
On Thu, 1 Mar 2001, Daren Cotter wrote:
> Ok, here goes...
>
> mysql> select member_id, signup_date from members order by member_id desc
> limit 410;
> +---+-+
>
32: Can't find record in 'members'
I have checked the tables using the checking utility, they show up fine.
What's going on? =)
-Original Message-
From: Quentin Bennett [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 4:45 PM
To: 'Daren Cotter'; [EMA
On Thu, 1 Mar 2001 19:32:54 -0800, "Daren Cotter" <[EMAIL PROTECTED]>
wrote:
>>So, the question is, why does this not return 400, like it should???
>>
>>OK, weird! Now I am getting this error...
>>
>>mysql> select count(*) from members where signup_date = '2001-03-01';
>>ERROR 1032: Can't find re
On Thu, 1 Mar 2001, Daren Cotter wrote:
> Ok, here goes...
>
> mysql> select member_id, signup_date from members order by member_id desc
> limit 410;
> +---+-+
> | member_id | signup_date |
> +---+-+
> (here's the last 20 or so rows)
> | 0120472 | 2001-0
e checked the tables using the checking utility, they show up fine.
What's going on? =)
-Original Message-
From: Quentin Bennett [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 4:45 PM
To: 'Daren Cotter'; [EMAIL PROTECTED]
Subject: RE: more date problems
Can you post s
age-
From: Daren Cotter [mailto:[EMAIL PROTECTED]]
Sent: Friday, 2 March 2001 3:34 p.m.
To: Quentin Bennett; 'Daren Cotter'; [EMAIL PROTECTED]
Subject: RE: more date problems
Quentin,
that does not work either, I still get the 125 number, when there are
actually 500 records
D]
Subject: RE: more date problems
Hi,
Can you try "where signup_date > '2001-02-28 23:59:59'", and see what that
gives.
Also, what version are you on - I have had some date problems where the end
of one month and the begining of another get confused (usually when doing a
Hi,
Can you try "where signup_date > '2001-02-28 23:59:59'", and see what that
gives.
Also, what version are you on - I have had some date problems where the end
of one month and the begining of another get confused (usually when doing a
UNIX_TIMESTAMP).
Maybe then use mysqlbug to report the is