安裝中文字典英文字典辭典工具!
安裝中文字典英文字典辭典工具!
|
- subquery - MySQL Error 1093 - Cant specify target table for update in . . .
DELETE FROM story_category WHERE category_id NOT IN ( SELECT DISTINCT category id FROM category INNER JOIN story_category ON category_id=category id); But I get the next error: #1093 - You can't specify target table 'story_category' for update in FROM clause How can I overcome this?
- You cant specify target table for update in FROM clause
I don't think the reason is inane Think about the semantics Either MySQL has to keep a copy of the table before the update started, or the inner query might use data that has already been updated by the query as it's in progress Neither of these side-effects is necessarily desirable, so the safest bet is to force you to specify what will happen using an extra table
- mysql - Error Code: 1093. You cant specify target table for update in . . .
Error Code: 1093 You can't specify target table for update in FROM clause Ask Question Asked 4 years, 1 month ago Modified 4 years, 1 month ago
- mysql error code 1093: You cant specify target table for update in . . .
I may be doing something wrong, I searched for it before and I find some workarounds that tell me that it can't be possible on MySQL, others are posting that it's due to MySQL optimizer so you can
- mysql - Error Code: 1093. You cant specify target table c for update . . .
I'm trying to prepare myself for feature interviews and while I was trying to solve this problem I have encountered some issues at the last exercise C) I have recreated these tables on my local da
- How to resolve MySQL error You cant specify target table X for update . . .
The reason why this doesn't work is that MySQL doesn't allow you to reference the table that you are updating (cancome) within a subquery This can however be overcome by using a query instead of the table itself in the FROM, which has the effect of copying the requested table values instead of referencing the one that you are updating So effectively this, even if counter intuitive, will work :
- sql - Error #1093 - Table is specified twice, both as a target for . . .
Your query is non-sensical It will delete no rows, ever (well, I suppose there could be a race condition where a new email is inserted during the course of the query and a dirty read)
- sql - How do I fix my MySQL error 1093 - Stack Overflow
How to fix this error [Err] 1093 - You can't specify target table 'user_log' for update in FROM clause
|
|
|