MySQL Query For Copying Contents Into Another Field, Same Row

Question

Is there a single query (subqueries in it are allowed) where I can copy the content of one field into another field, per row. Example:

price, and priceBackup

Records:

45.55

47.77

45.55 copies into priceBackup for that specific row,

47.77 copies into priceBackup for that specific row.

I do have a primary key, auto increment on it under 'id'.

Thanks guys!

Answer 1

UPDATE table1 SET priceBackup = price

Add a WHERE clause if you only want to do this for some rows.

Answer 2

update table blah set priceBackup=price;