SQL command to copy unit price to wholesale price?

[DexSnake]

So I just realized after importing 40,000 products over the last 6 months that I have been putting our "supplier" price (the price we buy for) in the unit price field. (stupid, I know). I would like to move all of those prices to the CORRECT field of wholesale price. I would rather not have to export and re-import everything. Could someone provide me with a SQL command to automate this for me?

[tuk66]

UPDATE ps_product SET wholesale_price = price;

UPDATE ps_product_shop SET wholesale_price = price;

Of course, backup first.