use in in mysql,if the field is indexed,the index is still useful,but when the data quantity is small relative to the param in "in" parentheses,mysql optimizer will use ALL TABLE SCAN instead.
[@more@]来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/545828/viewspace-899680/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/545828/viewspace-899680/