mysql #1093 - You can't specify target table error

Theodore Murdock

DELETE FROM story_category
WHERE category_id NOT IN (
    SELECT cid FROM (
        SELECT DISTINCT category.id AS cid FROM category 
        INNER JOIN story_category ON category_id=category.id
    ) AS c
)

Add Own solution

Log in, to leave a comment

Are there any code examples left?

Find Add Code snippet

New code examples in category SQL

SQL 2022-03-27 22:45:25 how to get mysql on ubuntu
SQL 2022-03-27 20:00:47 install latest mysql on debian 9
SQL 2022-03-27 19:45:11 sql '=' cannot be applied to date varchar(10) athena
SQL 2022-03-27 19:20:41 sql is not null
SQL 2022-03-27 19:20:39 sql group by error
SQL 2022-03-27 18:35:10 replace null with 0 in sql
SQL 2022-03-27 17:30:32 concat column value of same user in mysql
SQL 2022-03-27 17:05:02 sql developer sql worksheet not showing
SQL 2022-03-27 16:45:07 kill a pid redshift
SQL 2022-03-27 16:00:09 joins in sql server

Create a Free Account

Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.

Develop soft skills on BrainApps

Complete the IQ Test

Relative searches

Error in query (1093): You can't specify target table mysql Error Code: 1093. You can't specify target table for update in FROM clause mysql error 1093 - can't specify target table for update in from clause Error Code: 1093. You can't specify target table 'medicine_variants' for update in FROM clause you can't specify target table for insert in from clause Error Code: 1093. You can't specify target table 'history' for update in FROM clause 0.000 sec You can't specify target table 'tbl_messages' for update in FROM clause You can't specify target table 'uf' for update in FROM clause 1093: You can't specify target table 'compras_fornecedores' for update in FROM clause 1093 - You can't specify target table '' for update in FROM clause #1093 - You can't specify target table 'T1' for update in FROM clause [HY000][1093] You can't specify target table 'users' for update in FROM clause mysql 1093 ou can't specify target table 'transaction' for update in FROM clause sql 1093 You can't specify target table 'ft_500_2k' for update in FROM clause can't specify target table for update in from clause ERROR 1093 (HY000): You can't specify target table 'tripbpoint' for update in FROM clause You can't specify target table 'Tested' for update in FROM clause #1093 - You can't specify target table '1459630_form_1' for update in FROM clause SQL Error [1093] [HY000]: You can't specify target table 'external_media' for update in FROM clause you cant specify target table You can't specify target table 'fact' for update in FROM clause You can't specify target table 'AssetInstanceTracker' for update in FROM clause You can't specify target table 'cmts' for update in FROM clause django mysql 1093, "You can't specify target table E OperationalError: (1093, "You can't specify target table 'sales_flat_order' for update in FROM clause") You can't specify target table 'ergo' for update in FROM clause error code 1093 mysql you can't specifiy target table You can't specify target table 'ad_group' for update in FROM clause my sql Error Code: 1093. You can't specify target table 's' for update in FROM clause You can't specify target table '__smeal_students_major' for update in FROM clause Error Code: 1093. You can't specify target table 'NewCopyOfCustnewTable' for update in FROM clause You can't specify target table 'wallet' for update in FROM clause 0.094 sec You can't specify target table 'flipbook_content' for update in FROM clause You can't specify target table 'categories' for update in FROM clause You can't specify target table 'orderpicking_aggiuntivi' for update in FROM clause You can't specify target table 'log' for update in FROM clause You can't specify target table 'storiarecupero' for update in FROM clause ou can't specify target table 'ip' for update in FROM clause You can't specify target table 'tbl_post_share' for update in FROM clause ER_UPDATE_TABLE_USED: You can't specify target table 's1' for update in FROM clause : You can't specify target table 'cc' for update in FROM clause] in EXECUTE("UPD You can't specify target table 'UserPermission' for update in FROM clause ou can't specify target table 'nt' for update in FROM clause You can't specify target table 'group_user' for update in FROM clause You can't specify target table 'attachment_filter' for update in FROM clause 1093 - You can't specify target table for update in FROM clause You can't specify target table 'sites' for update in FROM clause Error Code: 1093. You can't specify target table for update in FROM clause You can't specify target table 'messages' for update in FROM clause You can't specify target table you can't specify target table for update in from clause You can't specify target table '#__finder_taxonomy' for update in FROM clause mysql can't specify target table for update in from clause mysql error 1093 You can't specify target table 'tbca' for update in FROM clause while delete mysql update on target table php sql You can't specify target table 'eav_attribute_option_value' for update in FROM clause Error Code: 1093. You can't specify target table 'contacts' for update in FROM clause Error Code: 1093. You can't specify target table 'customers' for update in FROM clause Error Code: 1093. You can't specify target table 'tbl_work_items' for update in FROM clause mysql you cant specify target table for update in from clause workbench import database error 1093 error code 1093 mysql update ou can't specify target table 'smite__partidas' for update in FROM clause You can't specify target table 'pets' for update in FROM clause Failed to execute query. Error: Foreign key 'UserNo' references invalid column 'UserNo' in referencing table 'accounts'. Could not create constraint or index. See previous errors. sql error (1093): you can't specify target table for update in from clause mysql you can't specify target table for update in from clause sql Error Code: 1093 Error Code: 1093. You can't specify target table 'orders' for update in FROM clause

Made with love

Welcome Back!

Sign up to unlock all of IQCode features:

Test your skills and track progress
Engage in comprehensive interactive courses
Commit to daily skill-enhancing challenges
Solve practical, real-world issues
Share your insights and learnings

Create an account

Create a Free Account

Sign up to unlock all of IQCode features:

Test your skills and track progress
Engage in comprehensive interactive courses
Commit to daily skill-enhancing challenges
Solve practical, real-world issues
Share your insights and learnings

Create an account

Creating a new code example