Export SQL table to CSV using command

4 posts
[expired user #11800]'s profile image [expired user #11800] posted 5 years 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.

94 posts
Misha v.3's profile image Misha v.3 posted 5 years ago Permalink

You should use mysqldump.exe to do this.

4 posts
[expired user #11800]'s profile image [expired user #11800] posted 5 years ago Permalink

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

4 posts
[expired user #11800]'s profile image [expired user #11800] posted 5 years ago Permalink

Any automation tool can help?

10011 posts
ansgar's profile image ansgar posted 5 years ago Permalink

As Misha said - mysqldump is perfectly automatable.

4 posts
[expired user #11800]'s profile image [expired user #11800] posted 5 years 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.