Forgot to add product weight - is there a sql command?

HI there
Version 4.2
I forgot to add product weight when i uploaded my products. I have 4000 products so dont really want to delete them all and start again.
Is there anyway using a sql command to enter the product weight? It can actually the same as the price of the product.
So if the price is 10 then the weight can be 10.
Thanks for any advice !

Hi,
You can update the product weight with the product price using the following SQL script

Use [YourDatabaseNameHere]
Go
Update Product set Weight=Price

RE: "...product weight... It can actually the same as the price of the product"

You really only need weight if your shipping rate is dependent on it.  (E.g using Shipping By Weight, or a carrier like FedEx, etc.)

(why would weight be same as price?)