MySQL + UPDATE SELECT Statement + #1093 – You can’t specify target table for update in FROM clause
[contentblock id=300squaretextlink] [contentblock id=300squareimagelink] What I Was Trying To Do I needed to do an Update Select using MySQL, I was expecting it to be something like: UPDATE MyTable SET HitCount = ( SELECT sp.HitCount+1 FROM MyTable sp WHERE sp.email = ‘test@email.com’ ) WHERE email = ‘test@email.com’ Error Message I Got Unfortunately, that returned the… Read more MySQL + UPDATE SELECT Statement + #1093 – You can’t specify target table for update in FROM clause