SHOW STATS FOR table SHOW STATS FOR ( SELECT * FROM table [ WHERE condition ] )
Returns approximated statistics for the named table or for the results of a (limited) query.
Statistics are returned for each column, along with a summary row.
|The name of the column (|
|The total size in bytes of all of the values in the column|
|The number of distinct values in the column|
|The portion of the values in the column that are |
|The number of rows (only returned for the summary row)|
|The lowest value found in this column (only for some types)|
|The highest value found in this column (only for some types)|