- 有趣的电影
错误示范:
因为我使用的是取整,而不是取余,需要取余得到想要的结果(且写法错误)
sql支持取余,mod()–取余
select * from ciname where movie=(select movie from ciname where id //2!=1 and description !='boring') order by rating desc
这里有sql支持的运算符
https://blog.csdn.net/Aggressive_snail/article/details/54907522
官网sql:(比较慢)
https://dev.mysql.com/doc/refman/5.7/en/non-typed-operators.html
正确示范1:
mod()–返回除法余数
select * from cinema where mod(id,2)=1 and description !='boring' order by rating desc
正确示范2:
使用 % —取余符号
not like 等价于 !=
这个效率更高
select * from cinema where id%2!=0 and description not like 'boring' order by rating desc;