|
When I use the statement: EXPLAIN SELECT * FROM workunits WHERE Sent>0 It returns +-----------+------+---------------+--------+---------+--------+---------+------------+ | table | type |
possible_keys | key | key_len | ref |
rows | Extra | +-----------+------+---------------+--------+---------+--------+---------+------------+ | workunits | ALL |
[NULL] | [NULL] | [NULL] |
[NULL] | 2297055 | where used | +-----------+------+---------------+--------+---------+--------+---------+------------+ Which is the same as performing: EXPLAIN SELECT * FROM workunits But If I SELECT * FROM `workunits` WHERE Sent>0 I Get: +----------------+-------+--------+-------+--------+-------+--------+------+----------------+----------------+----------------+ |
wuid | ETilt |
ETilt2 | MTilt | MTilt2 | STilt | STilt2 | Sent | ProcessByHost1 |
ProcessByHost2 | ProcessByHost3 | +----------------+-------+--------+-------+--------+-------+--------+------+----------------+----------------+----------------+ | 2222.11.6267.1 | 22 |
22.1 | 1.6 | 2
| 6 | 7.1 | 2
|
2
|
1
|
0 | | 2222.11.6267 | 22
| 22.1 | 1.6 | 2
| 6 | 7
| 2 |
2
|
1
|
0 | | 2222.11.6266.9 | 22 |
22.1 | 1.6 | 2
| 6 | 6.9 | 2
|
2
|
1
|
0 | | 2222.11.6266.8 | 22 |
22.1 | 1.6 | 2
| 6 | 6.8 | 2
|
2
|
1
|
0 | | 2222.11.6266.7 | 22 |
22.1 | 1.6 | 2
| 6 | 6.7 | 1
|
2
|
0
|
0 | | 2222.11.6266.6 | 22 |
22.1 | 1.6 | 2
| 6 | 6.6 | 1
|
2
|
0
|
0 | +----------------+-------+--------+-------+--------+-------+--------+------+----------------+----------------+----------------+ Only 6 rows in set I am using MySQLd 3.23.44 If I should upgrade which is probably a good idea,
what version should I get? Chris |
No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 266.5.2 - Release Date: 28/02/2005
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
