Hi! this is a beginner's question about MySQL. I have looked at the online MySQL documentation and have not found an answer.
I am looking for suggestions to read a fixed-column format file into a MySQL database with about 50,000 observations and 400 variables (fields). Each variable is in 2--5 colums of a text file with no column delimiters and blanks for missing values. Also, how do I create field names and labels for the values in each field? This will be used for creating subsets for statistical analysis. Also, which table type is good for this purpose? I will be thankful for any suggestion on this. anupam. --------------------------------------------------------------------- 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