how to take tab delimited export with mysql

you can use mysqldump to take a dump of a table or a database.
when you use the command without a parameter dump is taken with insert statements.

if you want to have a tab delimeted export file you should use --tab paramter with mysqldump.

shell > mysqldump --tab=/path_to_dump_files database table

after this command table.sql and table.txt files will be created. sql for table structure and txt file for data.