MySQL Forums
Forum List  »  Newbie

How to run multiple query?
Posted by: Emako Online
Date: December 23, 2022 02:13AM

Hello Fellow MySQL Users,

I am trying for some months to achieve a fast result in PHP + MYSQL coding.

I have a MySQL database in SERVER A, where are listed 350+ tables with products, like:

manu_akrapovic(sku,price,status,delivery_notes)
manu_alpinestars(sku,price,status,delivery_notes)
...
manu_ztechnik(sku,price,status,delivery_notes)

I have a webshop also PHP + Mysql database which contains about 200.000SKUs in SERVER B.

Is any fast way how to update those (sku,price,status,delivery_notes) in SERVER B (webshop) on daily basis?
This means those 200.000SKUs must be looking at the SERVER A database on daily basis.

I appreciate your help in this matter.
Thank You
Best Regards
Roni

Options: ReplyQuote


Subject
Written By
Posted
How to run multiple query?
December 23, 2022 02:13AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.