Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Export SQL table to CSV using command

4 posts

knkirubakaran posted 5 years ago in Import/Export

Can you help me to Export SQL table to CSV using command. We knoe Export grid option to manual export, but we need using by query.

94 posts

Misha v.3 posted 5 years ago

You should use mysqldump.exe to do this.

4 posts

knkirubakaran posted 5 years ago

We need to export CSV from DB and make it Zip and upload to FTP

4 posts

knkirubakaran posted 5 years ago

Any automation tool can help?

9832 posts

ansgar posted 5 years ago

As Misha said - mysqldump is perfectly automatable.

4 posts

knkirubakaran posted 5 years ago

Thanks for the response.

Can you help me to export csv with delimited text with select statement? like below screenshot in SQL statement.

1 attachment(s):

Please login to leave a reply, or register at first.