mysql - 为什么我在这个 if 语句上遇到错误？

Question

select if
(
(min(student_number)>1) or (max(student_number)<5500),'ok','Check Students'
)
from students;

Answer 1

您应该将 OR 替换为 AND:

select if
(
(min(student_number)>1) and (max(student_number)<5500),'ok','Check Students'
)
from students;