UPDATE movie_temp SET movie_release_year = ( substring_index(movie_title,')',1) ) WHERE movie_title IN (SELECT * FROM (SELECT movie_title FROM movie_temp) AS TEMP);
When executing the above query (movie_temp table has more than 660,000 rows),
after 600 seconds workbench throws me errors
Error Code: 2013Lost connection to MySQL server during query followed by
Error Code: 2006MySQL server has gone away.
I changed max_allowed_packet to 512MB, wait_timeout to 30 but no use.
Can someone help me with this?