Bonjour,
I have a table with 111619 rows in it.
"show table status" and "select count(*)" don't return the same
number of rows.
Is this know ?
mysql> show table status like 'livequote_FSE';
+---------------+----------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------
------+----------------+----------------------------+
| Name | Type | Row_format | Rows | Avg_row_length | Data_length |
|Max_data_length | Index_length | Data_free | Auto_increment | Create_time |
|Update_time | Check
_time | Create_options | Comment |
+---------------+----------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------
------+----------------+----------------------------+
| livequote_FSE | Innobase | Fixed | 172281 | 119 | 20529152 |
| NULL | 0 | 0 | NULL | NULL | NULL |
|NULL
| | ; Innobase free: 459776 kB |
+---------------+----------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------
------+----------------+----------------------------+
1 row in set (0.19 sec)
mysql> select count(*) from livequote_FSE;
+----------+
| count(*) |
+----------+
| 111619 |
+----------+
1 row in set (0.22 sec)
Regards,
Alex.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php