SQL UPDATE with sub-query that references the same table in MySQL

by

Some reference for you http://dev.mysql.com/doc/refman/5.0/en/update.html

UPDATE user_account student 
INNER JOIN user_account teacher ON
   teacher.user_account_id = student.teacher_id 
   AND teacher.user_type="ROLE_TEACHER"
SET student.student_education_facility_id = teacher.education_facility_id

More Related Contents:

  1. SQL DELETE with JOIN another table for WHERE condition
  2. MySQL #1093 – You can’t specify target table ‘giveaways’ for update in FROM clause
  3. Select from same table as an Insert or Update
  4. Deleting a row based on the max value
  5. Insert and set value with max()+1 problems
  6. Which DB technology is sued to solve the following search issue? [closed]
  7. MySQL pivot row into dynamic number of columns
  8. Rank function in MySQL
  9. Count the number of occurrences of a string in a VARCHAR field?
  10. Find nearest latitude/longitude with an SQL query
  11. MySQL: Split comma separated list into multiple rows
  12. Most efficient way to get table row count
  13. Subqueries with EXISTS vs IN – MySQL
  14. What is this operator in MySQL?
  15. Remove Primary Key in MySQL
  16. 60 million entries, select entries from a certain month. How to optimize database?
  17. Get most recent row for given ID
  18. Is it possible to GROUP BY multiple columns using MySQL?
  19. MySQL monthly Sale of last 12 months including months with no Sale
  20. Is merge statement available in MySQL
  21. Mysql covering vs composite vs column index
  22. MYSQL syntax not evaluating not equal to in presence of NULL
  23. MySQL: LAST_INSERT_ID() returns 0
  24. Calculating a Moving Average MySQL?
  25. INSERT INTO or UPDATE with two conditions
  26. Calculating time difference between 2 dates in minutes
  27. MySql. How to use Self Join
  28. SQL doesnt differentiate u and ü although collation is utf8mb4_unicode_ci
  29. What does it mean by select 1 from table?
  30. ORDER BY alphabet first then follow by number

Leave a Comment