总结:
mysql 数据库字段为null时 token_app加了索引
1.
SELECT * FROM `user` WHERE token_app='xxx'
SELECT * FROM `user` WHERE token_app is null
上面的都会走索引
2.
SELECT * FROM `user` WHERE token_app is not null
is not null不会走索引
3.数据过少时会全表扫描 mysql的优化器决定的 如果全表扫描比走索引快,就会全表扫描