首页 > IT职业 > > 求大佬解释这两个SQL语句
select id from app where id in (select id from app limit 1);
select id from app where id in (select id from (select id from app limit 1) as t);
第一个报错:
select id from app where id in (select id from app limit 1)
1235 - This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
第二个正确.
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/69900308/viewspace-3155787/ ,如需转载,请注明出处,否则将追究法律责任。