How to update data from another phpMyAdmin table?

T

televnoy2018-02-20 08:39:34

MySQL

televnoy, 2018-02-20 08:39:34

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