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

1 vote392 views1 answer
Mysql breakline on string
SQL
1 vote396 views1 answer
Sql order by timestamp
SQL
0 vote353 views1 answer
Optimize sql query
SQL
50 votes426 views4 answers
Sql alter type of column
SQL
2 votes362 views1 answer
Laravel sql String
SQL
0 vote351 views1 answer
Limit and offset in stored procedure mssql
SQL
4 votes348 views1 answer
Adding data to table in sql python
SQL
0 vote359 views1 answer
Enable full text search mysql
SQL
4 votes336 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
0 vote340 views1 answer
Python mysql query where
SQL