At 7:19 +0000 9/27/06, [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?
LOAD DATA doesn't allow for variable-width separator. You can preprocess
you data to convert runs of spaces to a single space (or some other character
that doesn't appear in your data), and the load the preprocessed result
with LOAD DATA.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]