MySQL update table based on another tables value

by 
UPDATE TABLE2
       JOIN TABLE1
       ON TABLE2.SERIAL_ID = TABLE1.SUBST_ID
SET    TABLE2.BRANCH_ID = TABLE1.CREATED_ID;

More Related Contents:

  1. MySQL update a joined table
  2. left join query keep a column empty
  3. UPDATE multiple rows with different values in one query in MySQL
  4. Multiple Updates in MySQL
  5. MySQL JOIN ON vs USING?
  6. MySQL error code: 1175 during UPDATE in MySQL Workbench
  7. mysql after insert trigger which updates another table’s column
  8. How to select from two tables in MySQL even if not all rows in one table have corespondents in the other?
  9. What’s the difference between comma separated joins and join on syntax in MySQL? [duplicate]
  10. MySQL JOIN the most recent row only?
  11. How to prepend a string to a column value in MySQL?
  12. mysql query show multiple tables from one ID column
  13. LEFT JOIN only first row
  14. MySql update two tables at once
  15. MySQL Inner Join Query Multiple Tables
  16. What are differences between INSERT and UPDATE in MySQL?
  17. Table is ‘read only’
  18. Difference between these two joining table approaches?
  19. MySql – Way to update portion of a string?
  20. MySQL Error: Incorrect usage of UPDATE and LIMIT
  21. MySQL LEFT JOIN 3 tables
  22. MySQL UPDATE and SELECT in one pass
  23. What is the default MySQL JOIN behaviour, INNER or OUTER?
  24. MySQL Join Where Not Exists
  25. how to use a like with a join in sql?
  26. The best way to remove value from SET field?
  27. MySQL: How do I use delimiters in triggers?
  28. Update MySQL with if condition
  29. MySQL behavior of ON DUPLICATE KEY UPDATE for multiple UNIQUE fields
  30. How to store a one to many relation in MySQL database?

Leave a Comment