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

knkirubakaran's profile image knkirubakaran posted 1 year ago in Import/Export Permalink

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.

Misha v.3's profile image Misha v.3 posted 1 year ago Permalink

You should use mysqldump.exe to do this.

knkirubakaran's profile image knkirubakaran posted 1 year ago Permalink

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

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.
knkirubakaran's profile image knkirubakaran posted 1 year ago Permalink

Any automation tool can help?

ansgar's profile image ansgar posted 1 year ago Permalink

As Misha said - mysqldump is perfectly automatable.

knkirubakaran's profile image knkirubakaran posted 1 year ago Permalink

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):
  • test

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