How to link SQL + cron + FTP?

Question

MySQL

Colleagues! With this spring and the past holidays :)
Please help me in solving this problem.
Given:
SQL database
FTP account (host, whatever)
Task:
Write a cron for SQL that will export data from a SQL database in CSV format.
Teach cron (but most likely you will need a gasket) to copy the resulting file to FTP.
I have no idea what to look for and where to look.
How to solve the problem?
Thanks to all!

Answer 1

Export
https://michaelrigart.be/export-directly-mysql-csv/
How to run query
https://dev.mysql.com/doc/refman/5.7/en/mysql-batc...
How to set up cron
www.rhd .ru/docs/manuals/enterprise/RHEL-AS-2.1-Man...
How to transfer a file via ftp
https://superuser.com/a/323268