T
T
televnoy2018-02-20 08:39:34
MySQL
televnoy, 2018-02-20 08:39:34

How to update data from another phpMyAdmin table?

Good day, dear "Toasters" =)
Help me make a SQL query for phpMyAdmin. There are two tables s_products and s_variants .
id_products/ s_variants = id/ s_produсts
Known sku/ s_variants Search
for known sku/ s_variants , find out id_produсts/ s_variants
From the id_products/ s_variants row of the price / s_variants column , update the data in the id/ s_products row of the extra_price / s_products column and
extra_comp_price / s_products get price/ s_variants = extra_price/ s_produсts = extra_comp_price/ s_products

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question