Top

mysql update from another table

mysql update from another table

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.

  1. Open up phpmyadmin or similar database editor
  2. view the sql query below
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.

anthony@worcesterwideweb.com

5 Comments
  • Evert
    May 22, 2008 at 4:06 am

    Thanks! 🙂

    That was exactly what I was looking for!

    Regards,
    Evert

  • Mahshid
    February 21, 2009 at 8:44 pm

    thanx so much, Help me much 🙂

  • Sandy
    February 27, 2009 at 11:50 am

    thank you! thank you! thank you!

    Saved me from countless hours of more frustration 🙂

    It’s so easy when you see it too!

  • Brandon Buttars
    January 26, 2010 at 5:23 pm

    I can’t believe it was that easy. You are the person. Your code explained things well. Thanks.

  • Nicolas
    March 5, 2013 at 2:23 pm

    Wow that was easy. First search result furthermore.
    Thanks for posting it.

Post a Comment