Optimizing the data type of a table

We can use procedure analyse () to judge the type of table currently in use, which can make recommendations for optimizing the data types of columns in a data table, and can consider whether or not to implement optimizations as appropriate for the actual application. Grammar:
SELECT * from Tbl_name PROCEDURE analyse ();
SELECT * from Tbl_name PROCEDURE analyse (16,256);

Each column of the output proposes optimization recommendations for the data type of the columns in the data table. The second example tells procedure analyse () not to make recommendations for enum types that contain more than 16 or 256 bytes of value. Without such a restriction, the output information can be long, and the enum definition is often difficult to read.

I've tried, it's good. As follows:

Optimizing the data type of a table