This version of MySQL doesn‘t yet support ‘LIMIT & IN/ALL/ANY/SOME subquery‘解决

执行sql

SELECT * from waybill_print_data where id in 
(SELECT id from waybill_print_data where created_time is null limit 1000);

[SQL] SELECT * from waybill_print_data where id in (SELECT id from waybill_print_data where created_time is null limit 1000)
运行结果
[Info] 运行失败，原因：This version of MySQL doesn’t yet support ‘LIMIT & IN/ALL/ANY/SOME subquery’

改成这样子就可以了<