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.
PROCEDURE ANALYSE()
Moderator: General Moderators
Re: PROCEDURE ANALYSE()
Yes, it is 
Re: PROCEDURE ANALYSE()
For human, stupid. For machine, not bad.
- Christopher
- Site Administrator
- Posts: 13596
- Joined: Wed Aug 25, 2004 7:54 pm
- Location: New York, NY, US
Re: PROCEDURE ANALYSE()
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?
(#10850)