开发者

error in running query

开发者 https://www.devze.com 2023-01-19 20:10 出处:网络
where h.er = select ( p.er from tip p where p.os = \'Android\' OR \'iOS\' ) AND h.ssn开发者_运维问答 = (select h2.ssnfrom persons h2 where h2.ssn like \'213%\');
where h.er = select ( p.er from tip p where p.os = 'Android' OR 'iOS' ) AND h.ssn开发者_运维问答 = (select h2.ssn  from persons h2 where h2.ssn like '213%');

I am performing this function in mysql. IT is not letting me to do it. An error is coming like check the manual the mysql version cooresponds to. I am using 5.1.5.1 MYsql


Try replacing:

where p.os = 'Android' OR 'iOS' 

With:

where p.os = 'Android' OR p.os = 'iOS' 

Or:

where p.os IN ('Android', 'iOS')


Try putting the select inside the parenthesis as:

where h.er = ( select p.er fr...
             ^
0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号