I have a table with 62 fields, I loaded data into MYSQL table from text file using LOAD DATA INFILE...TERMINATE BY '|' ENCLOSED BY '!' After the load, I did a "describe" on that table, only the first 21 fields showed up. However, when I did "SELECT" on the missing fields, there were actually correct data in the fields. What went wrong? And how do I fix this problem? FC --------------------------------------------------------------------- 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