SQL 问题记录

in 和 or

测试 sql

in 或 or 在参数只有 4 个时 使用了索引，超过 4 个使用全表扫描

select * from t_goods_feature where category_id in (1,2,3,4,5,6,7,8)

select * from t_goods_feature where category_id =1 or category_id=2 or category_id =3 or category_id =4
or category_id =5 or category_id =6 or category_id =7 or category_id =8