On Tuesday 29 April 2008 08:21:37 Charles Lambach wrote: > Hi. > > I've got a table with some fields, which I created with VARCHAR(100). > > I want to optimize this table, and I want to modify the length of these > fields from VARCHAR(100) to VARCHAR(maximum_length), where "maximum_length" > is the length of the record with the longest field. > > I could create a Perl script to do it, but I wonder if there's a mySQL > command which does it automatically. > > Thank you very much, > --Charles
Couldn't you also use procedure analyse()? SELECT column FROM table PROCEDURE ANALYSE(10, 2000); kabel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]