I need to take the data from a file and insert it into a MySQL table. Is this the best function to use?

If so, how do you get this to work right? I've tried several things and have looked at the docs at mysql.com but haven't found much help.

I did this:

mysql> LOAD DATA LOCAL INFILE '/path/to/file' INTO TABLE test;

My test data file was simply like this:
...and so on for about 10 entries. But when I look to see what actually went into the table, I see this:

| ID | A |
| 10 | NULL |
| 9 | NULL |
| 8 | NULL |
| 7 | NULL |
...and so on.

So how do I get it so that it puts column1 into ID and column2 into A? I'm sure this is a simple thing, but I'm just not sure how to do this.

Thanks for any help you can give,