MySQL Query For Copying Contents Into Another Field, Same Row

Posted by Rob Adler on Stack Overflow See other posts from Stack Overflow or by Rob Adler
Published on 2010-03-29T23:55:00Z Indexed on 2010/03/30 0:03 UTC
Read the original article Hit count: 224

Filed under:

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!

© Stack Overflow or respective owner

Related posts about mysql