MySQL Load Data Separators
I am rather new to MySQL, I understand how to load data into a table from a text file that's columns are separated by tabs(white space) by default and I was reading that you specify the column value separator explicitly in the LOAD DATA statement. I've tried a number of combinations but i can't figure out where to specify the new separator?
mysql> LOAD DATA LOCAL INFILE 'bird.txt' INTO TABLE pet;
would be columns would be separated by tabs by default how would i specify say :'s or something other than tabs?