Im trying to set up an SQL Cron job that would look inside database 1 and if column2 is equal to subscribed then copy their username(which could be column1) and insert it in database 2 in the format of username, data1. It should also check the names of the people in database 2 and then make sure their still subscribed, and if they aren't, it should change the information in database 2,data2

I know this is a lot to ask. I've bin trying to figure this out but it's
a complex script. Any help would be much appreciated

(P.S. i've got the cron command i just need to make the .sql file, thats what i need help with)