mysql update from another table
July 3, 2007
Recently I needed to update a bunch of rows in mysql with information from another table. I will explain how to do this simple process.
- Open up phpmyadmin or similar database editor
- view the sql query below
Code (sql)
-
-
UPDATE updatefrom p, updateto pp
-
SET pp.last_name = p.last_name
-
WHERE pp.visid = p.id
Lets say we have 2 tables one named main and one named updateto and one named updatefrom, In the first line we assign variables to these t tables (p and pp) from there we can call column names using this format table.columname. If we had first_name and last_name in both tables and wanted to update the “updateto” table with the info from “updatefrom” this is how you would write it.
Posted by Anthony under PHP,Web Technology,mysql | Comments (4)
Thanks!
That was exactly what I was looking for!
Regards,
Evert
Comment by Evert — May 22, 2008 @ 4:06 am
thanx so much, Help me much
Comment by Mahshid — February 21, 2009 @ 8:44 pm
thank you! thank you! thank you!
Saved me from countless hours of more frustration
It’s so easy when you see it too!
Comment by Sandy — February 27, 2009 @ 11:50 am
I can’t believe it was that easy. You are the person. Your code explained things well. Thanks.
Comment by Brandon Buttars — January 26, 2010 @ 5:23 pm