views:

177

answers:

1

I have file in the following format:

`e00` `e01` `e02` `e03`
`e10` `e11` `e12` `e13

Trying to import the data with

LOAD DATA INFILE 'file' INTO TABLE 'foo' FIELDS TERMINATED BY ' ' ENCLOSED BY '`'

only seems to get the first 3 fields of each line. Is there a way to load the data without altering the file format?

+1  A: 

How many columns does 'foo' have?

searlea