Using MySQL, I would like to update a row from a table using another row from that same table, is this possible? Ideally something like this:
UPDATE table SET row 1 = row 2
DELETE row 2
I need to do this for many tables and I don't want to have to write a script in PHP for each table. It would be easy enough to read the data into PHP and then run another query to update the first row, but I will then have to do this for each table which is a pain.