How to export query result to text file using command line

Question

I want to export my query result to .txt or .csv file but using command.

I want to do something like this:

BULK "EXPORT" (Select * from MyTable) to 'C:\Users\admin\Desktop\filename.txt' WITH (FIELDTERMINATOR = '\t', ROWTERMINATOR = '\n')

How can i do this?

There is no BULK EXPORT, only BULK INSERT. Is bcp an option? — Thom A
– Thom A ♦, Commented Dec 21, 2018 at 18:19

Gaurav · Accepted Answer · 2018-12-21 18:49:42Z

3

Use SQLCMD as below -

    sqlcmd -S . -d DbName -E -s',' -W -Q "SELECT * FROM [Table]" > C:\Test.csv

You can also try BCP as below -

   bcp [BookDb].[dbo].[Books] out C:\Test1.csv -T

answered Dec 21, 2018 at 18:42

Gaurav

6236 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sanchi Girotra · Accepted Answer · 2019-06-14 05:08:53Z

0

I have used below statement to export tab separated data in csv

mysql -h$ip -u$user -p$password -P3310 $dbName -B -e "select * from a" > a_data.csv

answered Jun 14, 2019 at 5:08

Sanchi Girotra

1,38614 silver badges13 bronze badges