我有一个嵌套查询,并尝试查看查询中是否有任何全表扫描。delete from ACCESS where ACCESS.MESSAGEID in (select ID from MESSAGE where MESSAGE.CID = 'xzy67sd’)\G key_len: 8 rows: 1
Extra: Using where
我正在尝试执行以下查询。share set holder = 22 where SHARE_ID IN (select SHARE_ID from SHARE WHERE holder=1 LIMIT 10)#1235 - This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'