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