mysql update column with value from another table

In addition to this answer if you need to change tableB.value according to tableA.value dynamically you can do for example:

UPDATE tableB
INNER JOIN tableA ON tableB.name = tableA.name
SET tableB.value = IF(tableA.value > 0, tableA.value, tableB.value)
WHERE tableA.name = 'Joe'

Related Posts:

  1. MySQL – UPDATE multiple rows with different values in one query
  2. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  3. Unknown column in ‘field list’ error on MySQL Update query
  4. Unknown column in ‘field list’ error on MySQL Update query
  5. MySQL – Operand should contain 1 column(s)
  6. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  7. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  8. MySQL create table if not exists and insert record only if table was created
  9. How can I do an UPDATE statement with JOIN in SQL Server?
  10. How do I use properly CASE..WHEN in MySQL
  11. How can I do a FULL OUTER JOIN in MySQL?
  12. MySQL query String contains
  13. What’s the difference between VARCHAR and CHAR?
  14. Case statement in MySQL
  15. How to declare a variable in MySQL?
  16. MySQL Cannot Add Foreign Key Constraint
  17. How to split the name string in mysql?
  18. How do I import an SQL file using the command line in MySQL?
  19. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  20. mysql Foreign key constraint is incorrectly formed error
  21. MySQL: Invalid use of group function
  22. How can I return pivot table output in MySQL?
  23. Compare dates in MySQL
  24. MySQL “WITH” clause
  25. MySQL Multiple Joins in one query?
  26. Error Code: 2013. Lost connection to MySQL server during query
  27. MySQL syntax for Join Update
  28. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  29. how to drop partition without dropping data in MySQL?
  30. MySQL combine two columns into one column
  31. Simple way to calculate median with MySQL
  32. Error 1046 No database Selected, how to resolve?
  33. MySQL Error 1264: out of range value for column
  34. Oracle SQL: Update a table with data from another table
  35. Remove duplicate rows in MySQL
  36. How to SUM and SUBTRACT using SQL?
  37. I want to use CASE statement to update some records in sql server 2005
  38. Cast from VARCHAR to INT – MySQL
  39. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  40. How do you force mysql LIKE to be case sensitive?
  41. How to create a MySQL hierarchical recursive query?
  42. ERROR 1148: The used command is not allowed with this MySQL version
  43. Insert into a MySQL table or update if exists
  44. How to round down to nearest integer in MySQL?
  45. MySQL starts with searching issue
  46. Query to convert from datetime to date mysql
  47. Is it possible to GROUP BY multiple columns using MySQL?
  48. MySQL error: key specification without a key length
  49. Best way to test if a row exists in a MySQL table
  50. Check if MySQL table exists without using “select from” syntax?
  51. MySQL equivalent of DECODE function in Oracle
  52. The used SELECT statements have a different number of columns
  53. How to delete from multiple tables in MySQL?
  54. MySQL: Can’t create table (errno: 150)
  55. How to copy a row and insert in same table with a autoincrement field in MySQL?
  56. Join vs. sub-query
  57. updating table rows in postgres using subquery
  58. I want to use CASE statement to update some records in sql server 2005
  59. Alternative to except in MySQL
  60. Equivalent of explode() to work with strings in MySQL
  61. ROW_NUMBER() in MySQ
  62. MySQL OPTIMIZE all tables?
  63. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  64. MySQL – Get row number on select
  65. MySQL error: Unknown column in ‘where clause’
  66. How to truncate the text returned for a column in a MySQL query
  67. ORA-01779: cannot modify a column which maps to a non key-preserved table
  68. Using union and order by clause in mysql
  69. MySQL LIKE IN()?
  70. Update query using Subquery in Sql Server
  71. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  72. SQL SELECT WHERE field contains words
  73. How do I limit the number of rows returned by an Oracle query after ordering?
  74. incorrect syntax error CREATE VIEW must be the only statement in the batch
  75. PLS-00103: Encountered the symbol when expecting one of the following:
  76. How do you create a temporary table in an Oracle database?
  77. Commands out of sync; you can’t run this command now
  78. Is there a Max function in SQL Server that takes two values like Math.Max in .NET?
  79. How to calculate age (in years) based on Date of Birth and getDate()
  80. How to create id with AUTO_INCREMENT on Oracle?
  81. Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot
  82. How can I group by date time column without taking time into consideration
  83. “This SqlTransaction has completed; it is no longer usable.”… configuration error?
  84. How to execute mulitple statement SQL queries using $wpdb->query?
  85. Return number of items in a table with post id
  86. How do I find which articles are missing a featured image in The WordPress database?
  87. Debugging WordPress
  88. Importing Geo data into wordpress database
  89. Pull data and display as rows and columns
  90. Speeding SQL queries for a large database?
  91. I need a SQL command to delete specific authors and all posts connected with them
  92. How to get INSERT errors from $wpdb?
  93. Sql query does not work well
  94. How to change post published date to today date with SQL
  95. Do I need to sanitize $_POST[‘keyword’] before send to ‘s’ parameter?
  96. Display a number value from mysql query in WP
  97. how to SELECT meta values that are not null?
  98. Conditional statement within WP SQL query
  99. Sql query returns empty. But not
  100. Delete posts with word count less than x number of words

Leave a Comment