MYSQL OR与AND一起 的用法

MYSQL OR与AND一起 的用法

– 查询结果是id = 2且age = 20或者id=1
SELECT * from student WHERE id = 1 or id = 2 AND age = 20;

idage
119
220

– 查询结果是 id=1或id=2 且age = 20
SELECT * from student WHERE (id = 1 or id = 2 ) AND age = 20;

idage
220

版权声明:本文为lyu12345原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。