PROCEDURE ANALYSE()

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
onion2k
Jedi Mod
Posts: 5263
Joined: Tue Dec 21, 2004 5:03 pm
Location: usrlab.com

PROCEDURE ANALYSE()

Post 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.
User avatar
genconv
Forum Commoner
Posts: 34
Joined: Sun Jul 05, 2009 9:27 am

Re: PROCEDURE ANALYSE()

Post by genconv »

Yes, it is :D
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Re: PROCEDURE ANALYSE()

Post by califdon »

For human, stupid. For machine, not bad.
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Re: PROCEDURE ANALYSE()

Post 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?
(#10850)
Post Reply