Answers for "MySQL can’t specify target table for update in FROM clause (Updating same table from same select inner join table)"

MySQL can’t specify target table for update in FROM clause (Updating same table from same select inner join table)

UPDATE film 
SET film.language_id = 2
WHERE film.film_id IN (SELECT f.film_id 
					FROM film f
					INNER JOIN film_actor fa
					ON f.film_id = fa.film_id
					WHERE fa.actor_id = 12);

Posted by: Guest on May-02-2022

Code answers related to "MySQL can’t specify target table for update in FROM clause (Updating same table from same select inner join table)"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "MySQL can’t specify target table for update in FROM clause (Updating same table from same select inner join table)"

Code answers related to "MySQL can’t specify target table for update in FROM clause (Updating same table from same select inner join table)"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "MySQL can’t specify target table for update in FROM clause (Updating same table from same select inner join table)"

Code answers related to "MySQL can’t specify target table for update in FROM clause (Updating same table from same select inner join table)"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us