ERROR 1093 (HY000): You can't specify target table '%s' for update in FROM clause
UPDATE forms SET pos = (SELECT MIN(pos)-1 FROM forms) WHERE id=$id This doesn't work, error message: **You can't …
mysql select sql-update mysql-error-1093I can do this: SELECT t2.value + sum(t3.value) FROM tableA t2, tableB t3 WHERE t2.somekey = t3.somekey …
mysql mysql-error-1093I know this is a simple syntax issue. Trying to delete all users from a subquery: delete from users where …
mysql sql mysql-error-1093Error 1093 states that you can't UPDATE or DELETE using a subquery if your subquery queries the table you are deleting …
mysql sql sql-update sql-delete mysql-error-1093I have the same situation as this other question, but I don't want to select the rows, I want to …
sql mysql database mysql-error-1093I need to delete duplicate record from table in mysql. So i have a table name "employee" fields are empid, …
mysql phpmyadmin mysql-error-1093I have got MySQL error "You can't specify target table 'tasks' for update in FROM clause" running the following query: …
mysql sql mysql-error-1093