How to export data to .psv file in mysql with table headers?

Asked Aug 17 '17 at 05:49

Active Aug 17 '17 at 06:06

Viewed 103 times

i want to export my table data into a .psv file but i didn't get the column names in the resultant file. MY query is like

SELECT id,site,zip,'08/14/2017' as date,Imagelink,price,price_mult,Eprice,Eindicator,altprice,Altpricemult,Ealtprice,AltIndicator,pack,unit,uom,'' as size,product_id,upc,asin,category,description,note,rating,'' as valid,pageimage,aisle,orig_upc,job_number,sale_enddate INTO OUTFILE 'c:\\file_name.psv'
FIELDS TERMINATED BY '|' 
LINES TERMINATED BY '\n'
from table_name

is anyone have any idea how can i do it? because i have a large amount of data (almost 900000 rows and 50 columns in a table) which take too much time when i use union clause in this query to insert column names.

edited Aug 17 '17 at 06:06

asked Aug 17 '17 at 05:49

Shivam Goel

but it take too much time( almost 2 to 3 hours ) to execute my query because there is around 30 columns and table have almost 900000 rows. – Shivam Goel Aug 17 '17 at 05:55
any other way instead of using union or union all clause? – Shivam Goel Aug 17 '17 at 05:58

How to export data to .psv file in mysql with table headers?

0 Answers0