hi, everyone! I have a text file like this: 10:10:00 0 0 1 99 10:20:00 0 0 1 99 10:40:00 11 3 4 83 11:00:00 1 1 2 97 11:05:00 2 1 1 96
I need to load this file into a table, but I cannot figure out the syntax of LOAD DATA INFILE command. As you can see, the fields are separated by a variable number of blank spaces (not tabs). How can I do this? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]