Skip to Main Content

MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

I need help with an UPDATE Query to Update remote MySQL from local MS Access

User_PMXZAApr 17 2022

I have inherited a customer who has a local MS Access database and needs to mirror the data in Access to his MyPHP database on his website. I am VERY new to this but do have a general knowledge of SQL databases. So far the only thing I have found is to do a dump of the MS Access database and then create a new database on the GoDaddy site and import the dump file.

My preference would be to establish a connection with both datasets and then run a quick query that would do an INSERT for any new rows and do an UPDATE on any rows that have changed.
Can someone here help with the two queries?? I have been able to establish a connection with BOTH datasets using MS Excel, so I know my connections are good.
I have also connected to the MySQL data set using MySQL Workbench.
Thanks

Comments
Post Details
Added on Apr 17 2022
0 comments
109 views