Export SQL table to CSV using command

knkirubakaran posted 2 months 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.

Misha v.3 posted 2 months ago

You should use mysqldump.exe to do this.

knkirubakaran posted 2 months ago

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

knkirubakaran posted 2 months ago

Any automation tool can help?

ansgar posted 2 months ago

As Misha said - mysqldump is perfectly automatable.

knkirubakaran posted 2 months 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):
  • test

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