Export SQL table to CSV using command

[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.

[expired user #1502]'s profile image [expired user #1502] posted 5 years ago Permalink

You should use mysqldump.exe to do this.

[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

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

Any automation tool can help?

ansgar's profile image ansgar posted 5 years ago Permalink

As Misha said - mysqldump is perfectly automatable.

[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.