Sometimes we are not sure if the database design we have created
and our site has been using is correct and optimised. We all do
have this feeling at times don't we :)
Well, MySQL provides with PROCEDURE ANALYSE() to help us
detect inconsistencies in our database design by suggesting for
an optimal datatype and data length for columns.
The syntax for using PROCEDURE ANALYSE() is as
below:
SELECT ... FROM ... WHERE ... PROCEDURE
ANALYSE([max_elements,[max_memory]])
Ref: …
Showing entries 1 to 1
Jan
31
2017
Showing entries 1 to 1