MySql – Update table using select statment from same table

by 
update table as t1
inner join (
select field_id_46,field_id_47 from table where entry_id = 36) as t2
set t1.field_id_60 = t2.field_id_46,
    t1.field_id_61 = t2.field_id_47
where t1.entry_id = 45

or, simply

update table as t1,
(
select field_id_46,field_id_47 from table where entry_id = 36) as t2
set t1.field_id_60 = t2.field_id_46,
    t1.field_id_61 = t2.field_id_47
where t1.entry_id = 45

More Related Contents:

  1. Error related to only_full_group_by when executing a query in MySql
  2. MySQL: Insert record if not exists in table [duplicate]
  3. How to declare a variable in MySQL?
  4. Can you split/explode a field in a MySQL query?
  5. How do I escape special characters in MySQL?
  6. Enable remote MySQL connection: ERROR 1045 (28000): Access denied for user
  7. Grouping into interval of 5 minutes within a time range
  8. SQL counting all rows instead of counting individual rows
  9. MySQL – ERROR 1045 – Access denied
  10. Remote Connections Mysql Ubuntu
  11. ERROR 1044 (42000): Access denied for user ”@’localhost’ to database ‘db’
  12. MySQL InnoDB not releasing disk space after deleting data rows from table
  13. In MySQL, should I quote numbers or not?
  14. Dump all tables in CSV format using ‘mysqldump’
  15. MySQL add days to a date
  16. How can I loop through all rows of a table? (MySQL)
  17. Select columns across different databases
  18. LOAD DATA INFILE Error Code : 13
  19. MySql update two tables at once
  20. Returning query results in predefined order
  21. Table is ‘read only’
  22. Django MySQL full text search
  23. Proper database model for a user feedback system (an interesting case)
  24. MySQL Errno 150
  25. How to force MySQL to take 0 as a valid auto-increment value
  26. MySQL – Replace Character in Columns
  27. How do you manage databases in development, test, and production?
  28. MySQL LIKE vs LOCATE
  29. What does it mean by select 1 from table?
  30. Errno 121, duplicate key on write or update?

Leave a Comment