Ginger Cheng <[EMAIL PROTECTED]> wrote:
>I am just wondering if anyone has seen this before querying an innoDB table:
>
> select count(*) from Table where field1=3;
> returned 782 rows
>
> select count(*) from Table where field1=3 and field2 is not null;
> returned 666 rows
>
> Here come
Hello, MySQL Gurus,
I am just wondering if anyone has seen this before querying an innoDB table:
select count(*) from Table where field1=3;
returned 782 rows
select count(*) from Table where field1=3 and field2 is not null;
returned 666 rows
Here comes the shocking part:
select coun
