How to import a white space delimited text file using LOAD DATA INFILE ?

[Zojak_Quaguz]

This one perplexes me. I can't find anything in the documentation about it, and I would be surprised if MySQL doesn't include functionality for such a simple task.

 

LOAD DATA INFILE 'blah.txt' INTO TABLE blah FIELDS TERMINATE BY ' ' LINES TERMINATED BY '\n';

 

example file:

 

83726291 4

92923612 1

42093723 0

12321742 1

91283747 2

01249243 4

 

It keeps loading the entire line into a single field, so my table ends up with column 2 being NULL.

 

[Zojak_Quaguz]

Ok, now it's working. No idea why it wasn't before.