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

57 votes314 views6 answers
Mysql alter table add column
SQL
0 vote140 views1 answer
Soql user profile
SQL
9 votes140 views1 answer
Identity insert on sql server
SQL
-1 vote85 views2 answers
On delete set default sql server
SQL
0 vote147 views1 answer
Default column value in sql same as another column laravel
SQL
2 votes129 views1 answer
Set boolean flasksql
SQL
4 votes135 views1 answer
Postgres delete last row
SQL
0 vote124 views1 answer
Error in connection_import_file(conn@ptr, name, value, sep, eol, skip) : RS_sqlite_import: test.csv line 2 expected 11 columns of data but found 1
SQL
4 votes124 views1 answer
Mysql insert from local csv
SQL
0 vote129 views1 answer
C# add a textbox in mysql select
SQL