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;
> +---+-+
>
Cotter'; [EMAIL PROTECTED]
Subject: RE: more date problems
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)
|
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
mysqlbug to report the issue, and include the results of your
tests.
Not much help, I know, but the more information you post, the more help we
can be.
Regards
-Original Message-
From: Daren Cotter [mailto:[EMAIL PROTECTED]]
Sent: Friday, 2 March 2001 1:03 p.m.
To: [EMAIL PROTECTED]
Subj
okay, this is a follow-up to my past email...
since I KNOW more than 122 people have signed up today, I did the following
query:
SELECT signup_date, member_id FROM members ORDER BY member_id DESC limit
200;
there are at LEAST 200 people that have signed up today. however, when i do:
SELECT cou
10 matches
Mail list logo
