一、问题
> 1235 - This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
二、原因/解决方案
这个错误通常是由于MySQL版本太旧导致的。在旧版本的MySQL中,无法在子查询中使用LIMIT和IN / ALL / ANY / SOME子查询。您需要升级到MySQL的较新版本,以解决这个问题。或者,您可以尝试使用其他方法来编写查询,而不是使用子查询和LIMIT。
三、案例
select * from t_sku where sku in (
SELECT
sku
FROM
t_sku1 WHERE delivery = "发货退款" AND refund = '2023-04' ORDER BY refund DESC LIMIT 100)
- quot 39 subquery version supportquot 39 subquery version subquery join no 39 version chromedriver selenium supports version undefined supported behavior origin 39 xmlhttprequest supported application supported content 39 quot supported protocol disabled quot supported dynamic require notimplementederror quot supported wikitext quot https supported protocol