报错SQL:
select ucas_individual_proj.individual_proj_name from ucas_individual_proj where ucas_individual_proj.sid in(
select ucas_file_info.individual_proj_sid from ucas_file_info where ucas_file_info.individual_proj_sid is not null and ucas_file_info.pdf_path is not null limit 1, 10
);
提示错误信息:
1235 - This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
正确SQL:子查询多嵌套一层
select ucas_individual_proj.individual_proj_name from ucas_individual_proj where ucas_individual_proj.sid in(
select t.individual_proj_sid from
(select * from ucas_file_info where ucas_file_info.individual_proj_sid is not null and ucas_file_info.pdf_path is not null limit 1, 10) as t
);
更多推荐
MySQL8子查询提示:This version of MySQL doesn’t yet support ‘LIMIT & IN/ALL/ANY/SO
发布评论