graham23s Posted August 12, 2008 Share Posted August 12, 2008 Hi Guys, i have over 500 products in mysql like: old_price I new_price i really want to move all the prices from the new_price to the old_price field! is there anyway i can do this with 1 command or would i need to do every one manually! cheers guys Graham Link to comment https://forums.phpfreaks.com/topic/119378-copying-table-in-mysql/ Share on other sites More sharing options...
Jabop Posted August 12, 2008 Share Posted August 12, 2008 UPDATE table SET new_price=old_price Link to comment https://forums.phpfreaks.com/topic/119378-copying-table-in-mysql/#findComment-614978 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.