Inserting data from *.txt to mysql

[edzulis]

Hi,

I can't understund how to put data which is in text file separeted with space into mysql database. Anybody can help or give some link? 🙂

For example:

data in text.txt

1a 2a 3a 4a 5a 6a
1b 2b 3b 4b 5b 6b

mysql table:

id field1 field2 field3 field4 field5 field6

--

And why one space is long, but others short?

Big thanks!

[dar-k]

http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html