----- Original Message ----- From: "Mikhail Entaltsev" <[EMAIL PROTECTED]>
ME> Can you send result of the query, please: ME > select * from MyTable PROCEDURE ANALYSE(); Here you are : mysql> select * from MyTable PROCEDURE ANALYSE(); +--------------+----------+----------+----------------+-------+------------- ----------+---------+------------------------------+ |Field_name |Min_length|Max_length|Empties_or_zeros|Nulls |Avg_value_or_avg_length|Std |Optimal_fieldtype | +--------------+----------+----------+----------------+-------+------------- ----------+---------+------------------------------+ |MyTable.Field1| 1| 7 | 0 | 0|3988722.5930 |0.0000 |MEDIUMINT(7) UNSIGNED NOT NULL| |MyTable.Field2| 1| 7 | 573688 | 0|3212734.0355 |0.0000 |MEDIUMINT(7) UNSIGNED NOT NULL| |MyTable.Field3| 1| 47 | 204 | 0|8.2074 |NULL |VARCHAR(47) NOT NULL | |MyTable.Field4| 1| 50 | 71 | 0|24.5052 |NULL |VARCHAR(50) NOT NULL | |MyTable.Field5| 1| 51723 | 1 | 0|174.5134 |NULL |TEXT NOT NULL | |MyTable.Field6| 12| 14 | 3809075 | 0|63688541485.2995 |0.0000 |BIGINT(14) UNSIGNED NOT NULL | |MyTable.Field7| 1| 4 | 0 | 0|1646.5029 |2596.7715 |SMALLINT(4) UNSIGNED NOT NULL | +--------------+----------+----------+----------------+-------+------------- ----------+---------+------------------------------+ NB: > Table desc : > CREATE TABLE MyTable ( > Field1 int(10) unsigned NOT NULL auto_increment, > Field2 int(10) unsigned NOT NULL default '0', > Field3 varchar(50) NOT NULL default '', > Field4 varchar(50) NOT NULL default '', > Field5 text NOT NULL, > Field6 bigint(20) NOT NULL default '0', > Field7 int(10) unsigned NOT NULL default '0', > PRIMARY KEY (Field1), > KEY ReplyTo_Numero (Field2,Field1), > KEY indexF (Field7,Field2,Field6) > ) TYPE=MyISAM PACK_KEYS=1; Thanks David --------------------------------------------------------------------- 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
