PROCEDURE ANALYSE()

MySQL INDEX

If you want to analyze the columns structures of a MySQL table and want to view the actual data in your table with certain suggestion then you can get help from PROCEDURE ANALYSE(). For example, if any data present in your table and plays a big role in any decision making then this is very useful.

As overall this is just a suggestion for you when table data is not big enough. For a big table you might not get the right suggestion.

In phpmyadmin you can get a link called “Propose table structure” where you will get this functionality.

Suppose you are using a INT field for your primary key and you do not have too many rows then it will suggest you to use MEDIUMINT instead or if you use a VARCHAR field and for all the rows you have limited values then you will get a suggestion to use ENUM for limited values.

Example of PROCEDURE ANALYSE():

SELECT col1, col2 FROM tbl PROCEDURE ANALYSE(10, 2000);
where 10 is max_elements and 2000 is max_memory

For any types of queries, you can contact us on info@namasteui.com.

You may like:  Cursor in MySQL stored procedures

Leave a Reply

Your email address will not be published. Required fields are marked *