How to update database via remote script

[Les Dee]

I have managed to use the Workbench to write an SQL script to update a remote database - say to append records in a csv file to a table.

I am now looking to to see how to do the same but without Workbench, so I can automate the process.

I am using a Windows based pc.

I want to be able to receive a csv file via my FTP server which then will trigger the creation of some script which in turn will connect to the remote database and upload the new records - as I can now do manually using Workbench.

How can I achieve this level of automation?

If necessary, I do not mind if Workbench is open all the time and acts as an intermediary, as long as the whole process can be automated.

Thanks.