MySQL: Load data infile and ignore tab in file

view full story

http://serverfault.com – MySQL command I have so far: load data infile 'data.txt' into table foo (column_foobar); data.txt: bar1 bar2 bar3 Note the tab at beginning of each line. How can I ignore the tab with MySQL so that bar1, bar2, bar3 gets loaded in column_foobar? (HowTos)