How to synchronize access and mysql tables?

Question

PHP

tell me who came across
how to do one-way synchronization of tables from the access database in mysql.
now I am sending the data with a php script, but updating (via UPDATE) is not a good idea to
synchronize, preferably in real time or with a minimum delay
(OC windows 7)

Answer 1

What's wrong with updating via UPDATE? Naturally, everything should be within the framework of one transaction.
I usually have a full table transfer looks like this:
1. Start a transaction
2. For all tables
2a. Set the field `updated` = 0
2b to all rows of the table. Move rows via INSERT ON DUPLICATE KEY UPDATE with change `updated` = 1
2c. Delete rows where `updated` = 0
3. Complete transaction