Re: SELECT with 1,000,000 ROWS

2003-08-19 Thread Arno
Un beau jour, Victoria Reznichenko a écrit: > "Arno" <[EMAIL PROTECTED]> wrote: >> >> I have aproximately 1,000,000 rows and I would like to do some >> query. The >> first one is to get the number of row so I do : >> >> mysql> SELECT COUNT(*) FROM `Log`; >> +--+ >>> COUNT(*) | >> +

Re: SELECT with 1,000,000 ROWS

2003-08-19 Thread Victoria Reznichenko
"Arno" <[EMAIL PROTECTED]> wrote: > > I have aproximately 1,000,000 rows and I would like to do some query. The > first one is to get the number of row so I do : > > mysql> SELECT COUNT(*) FROM `Log`; > +--+ > | COUNT(*) | > +--+ > | 969129 | > +--+ > 1 row in set (0.00

Re: SELECT with 1,000,000 ROWS

2003-08-19 Thread Arno
Un beau jour, Nick Gaugler a écrit: >> Hello, >> >> I have aproximately 1,000,000 rows and I would like to do some >> query. The first one is to get the number of row so I do : >> >> mysql> SELECT COUNT(*) FROM `Log`; >> +--+ >>> COUNT(*) | >> +--+ >>> 969129 | >> +--+ >>

RE: SELECT with 1,000,000 ROWS

2003-08-19 Thread Nick Gaugler
> Hello, > > I have aproximately 1,000,000 rows and I would like to do some query. > The first one is to get the number of row so I do : > > mysql> SELECT COUNT(*) FROM `Log`; > +--+ > | COUNT(*) | > +--+ > | 969129 | > +--+ > 1 row in set (0.00 sec) MyISAM tables keep