MySQL 中 You can‘t specify target table ‘表名‘ for update in FROM clause错误解决办法

delete from ent_role_user
     where  (user_code ,role_code, tenant_code )
     in (
        select   user_code ,role_code,tenant_code
        from ent_role_user where user_code = #{userName}
        and tenant_code = #{tenantCode}
        and warehouse_code != '' and warehouse_code is not null
        and role_code in (select role_code  from ent_role where role_type =false   ) )
        and warehouse_code != '' and warehouse_code is not null

解决办法：中间加一个中间表

 delete from ent_role_user
     WHERE
	(user_code,role_code,tenant_code) IN (
	SELECT
		a.user_code,a.role_code,a.tenant_code
	FROM(
		SELECT
			user_code,role_code,tenant_code
		FROM
			ent_role_user
		WHERE
			user_code = #{userName}
			AND tenant_code = #{tenantCode}
			AND warehouse_code != ''
			AND warehouse_code IS NOT NULL
			AND role_code IN ( SELECT role_code FROM ent_role WHERE role_type = FALSE )
			AND warehouse_code != ''
			AND warehouse_code IS NOT NULL
		) a
	) and warehouse_code != '' and warehouse_code is not null

成功