Woocommerce mysql price table

//for Regular Price
UPDATE wp_postmeta 
SET meta_value = diff_price_value 
WHERE post_id = variation_id AND meta_key = '_regular_price';

//for Price
UPDATE wp_postmeta 
SET meta_value = price_value 
WHERE post_id = variation_id AND meta_key = '_price';

//for Sale Price
UPDATE wp_postmeta 
SET meta_value = price_value 
WHERE post_id = variation_id AND meta_key = '_sale_price';

Source: stackoverflow.com

Similar codes

0 vote110 views1 answer
Count number of entires by months sql
SQL
4 votes118 views1 answer
Id primary key auto generated
SQL
0 vote128 views1 answer
How to change mysql port in xampp
SQL
0 vote126 views1 answer
Get the next column of a table in mysql
SQL
0 vote102 views1 answer
What are the aggregate function in sql
SQL
0 vote118 views1 answer
Fill up postgres db
SQL
0 vote119 views1 answer
Connexion mysql
SQL
1 vote136 views1 answer
Mysql datetime with timezone offset
SQL
0 vote112 views1 answer
Postgresql default value boolean
SQL
0 vote115 views1 answer
Psql list view rules
SQL