Page 1 of 1

PROCEDURE ANALYSE()

Posted: Wed Jul 08, 2009 10:38 am
by onion2k
This is crazy...
[sql]SELECT *FROM `table`PROCEDURE ANALYSE()[/sql]
For a DATE column it suggests using "ENUM('2009-06-30','2009-07-01','2009-07-02','2009-...". That's really stupid.

Re: PROCEDURE ANALYSE()

Posted: Wed Jul 08, 2009 12:00 pm
by genconv
Yes, it is :D

Re: PROCEDURE ANALYSE()

Posted: Wed Jul 08, 2009 7:29 pm
by califdon
For human, stupid. For machine, not bad.

Re: PROCEDURE ANALYSE()

Posted: Wed Jul 08, 2009 7:36 pm
by Christopher
It seems like those analysis functions always recommend ENUM. They must know something that we don't know. I wonder what number of items in an ENUM is too many?