[EMAIL PROTECTED] wrote:
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?
Did you try using a space (' ') as the separator? Did you get an error?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
