You can’t specify target table for update in FROM clause
I have a simple mysql table: CREATE TABLE IF NOT EXISTS `pers` ( `persID` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(35) NOT NULL, `gehalt` … Read more
mysql-error-1093
MySQL Error 1093 – Can’t specify target table for update in FROM clause
I have a table story_category in my database with corrupt entries. The next query returns the corrupt entries: SELECT * FROM story_category WHERE … Read more