Conquering MySQL Update Errors: "You can't specify target table for update in FROM clause" Explained
This error arises when you attempt to update a table within a SQL statement while simultaneously referencing the same table in the FROM clause using a subquery