Command to describe optimum table definition

Hello all,
At some point in the past, I seem to recall being told about a console
command that would analyze a table's contents and recommend a table
definition to match? Not describe what the table -is- (I'm familiar with
DESC ), but what it could/should be.
I've looked through the MySQL site for indications of this command, and
reviewed the slides and certification guide briefly - but haven't found
anything. Am I missing something that's in plain sight, or was I
hallucinating when I thought I heard about this command?

Thanks in advance for any assistance,
Matt

--
Matt Bernhardt, bernhardt.7@osu.edu
Systems Analyst - Student Computing
Knowlton School of Architecture
The Ohio State University

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

RE: Command to describe optimum table definition

I don't think there is such a thing for MySQL unless there is a
third-party tool. MS Access has the "Analyse" facility that does
something like this. Perhaps you were thinking of that.

John Bonnett

-----Original Message-----
From: Matt Bernhardt [mailto:bernhardt.7@osu.edu]=20
Sent: Wednesday, 2 March 2005 1:39 AM
To: win32@lists.mysql.com
Subject: Command to describe optimum table definition

Hello all,
At some point in the past, I seem to recall being told about a
console =20
command that would analyze a table's contents and recommend a table =20
definition to match? Not describe what the table -is- (I'm familiar with

DESC ), but what it could/should be.
I've looked through the MySQL site for indications of this command,
and =20
reviewed the slides and certification guide briefly - but haven't found

anything. Am I missing something that's in plain sight, or was I =20
hallucinating when I thought I heard about this command?

Thanks in advance for any assistance,
Matt

--=20
Matt Bernhardt, bernhardt.7@osu.edu
Systems Analyst - Student Computing
Knowlton School of Architecture
The Ohio State University

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org