MySQL fields terminated by tab

Brian picture Brian · Apr 6, 2010 · Viewed 30.3k times · Source

I am trying to upload a tab delimitted file with MySQL. I want a query something likes this: LOAD DATA LOCAL INFILE 'file' INTO TABLE tbl FIELDS TERMINATED BY 'TAB' Is there something I can subsitute for TAB to make this work?

Answer

DRapp picture DRapp · Apr 6, 2010

have you tried '\t' the escape sequence + "T" is considered tab... haven't tried, but might be what you need