SELECT with 1,000,000 ROWS

2003-08-19 Thread Arno
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) mysql SELECT COUNT(*) AS `Nb` FROM `Log`

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 a specific

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 | +--+ 1 row in set (0.00 sec)

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 sec) mysql

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(*) | +--+ 969129 |