I was able to successfully update the mysql database using this query.

UPDATE OPENQUERY (MySQL, 'SELECT b FROM test WHERE a = 3')
SET b = 'test';

Is there a way to just set up queries to insert, update, delete the MySQL Database and not even use triggers? Or are triggers more convenient?

And how would one execute queries on let's say a nightly basis, If I were to make them?