MySQL Forums
Forum List  »  Newbie

how to duplicate column data
Posted by: Aaron
Date: April 16, 2005 04:40PM

The scenario:

I have a table. Mulitple columns. The two I'm concerned with are product values (prices). The first is the cover price for a magazine. The second is the purchase price for each issue. I want the purchase price to automatically match the cover price. This way, if I actually paid more for a particular issue, I only have to edit that one entry. Otherwise, the purchase price will always reflect the cover price as I input each new line.

How do I set this up if it's possible?

Options: ReplyQuote


Subject
Written By
Posted
how to duplicate column data
April 16, 2005 04:40PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.