Update row with data from another row in the same table

by

Try this:

UPDATE data_table t, (SELECT DISTINCT ID, NAME, VALUE
                        FROM data_table
                       WHERE VALUE IS NOT NULL AND VALUE != '') t1
   SET t.VALUE = t1.VALUE
 WHERE t.ID = t1.ID
   AND t.NAME = t1.NAME

More Related Contents:

  1. Out of memory Microsoft VBScript runtime error 800a0007
  2. MySQL how to fill missing dates in range?
  3. Left Outer Join doesn’t return all rows from my left table?
  4. How can i optimize MySQL’s ORDER BY RAND() function?
  5. Are table names in MySQL case sensitive?
  6. How to split the name string in mysql?
  7. Get table names using SELECT statement in MySQL
  8. ERROR 1396 (HY000): Operation CREATE USER failed for ‘jack’@’localhost’
  9. Can a foreign key reference a non-unique index?
  10. How to raise an error within a MySQL function
  11. Storing Data in MySQL as JSON
  12. How to set a maximum execution time for a mysql query?
  13. MySQL select statement with CASE or IF ELSEIF? Not sure how to get the result
  14. SQL keys, MUL vs PRI vs UNI
  15. How do I retrieve my MySQL username and password?
  16. Can’t Create Entity Data Model – using MySql and EF6
  17. LOAD DATA LOCAL INFILE gives the error The used command is not allowed with this MySQL version
  18. MySQL root password change
  19. How do you debug MySQL stored procedures?
  20. Schrödingers MySQL table: exists, yet it does not
  21. MySQL: How to select records for this week?
  22. ld: library not found for -lzstd while bundle install for mysql2 gem Ruby on macOS Big Sur 11.4 Apple M1
  23. How to migrate SQL Server database to MySQL? [closed]
  24. how to cast the hexadecimal to varchar(datetime)?
  25. MySQL Select Query – Get only first 10 characters of a value
  26. Rank() over Partition by in mysql
  27. Trouble with GROUP_CONCAT and Longtext in MySQL
  28. How to pass a variable to a IN clause?
  29. Optimistic locking in MySQL
  30. Insert and set value with max()+1 problems

Leave a Comment