Hi,
I try to optimize my tables. To see possible "errors" I use SELECT statements with
PROCEDURE ANALYSE. I have a table that holds unique strings and an index by whitch
it's referenced to another table. PROCEDURE ANALYSE advises as datatype for the
strings to take an enum of (String1,String2,String3,String4,String5,String6,... to
191) Why doesnt it simply (intelligently in that case) advise to take varchar(50)???
Best regards
Bernhard
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
