摘要： 表结构如下:mysql> select * from test;+----+-------+| id | name |+----+-------+| 1 | test1 || 2 | test2 || 3 | test3 || 4 | test4 || 5 | test5 |+----+-------+执行以下SQL:mysql> select * from test where id in(3,1,5);+----+-------+| id | name |+----+-------+| 1 | test1 || 3 | test3 || 5 | test5 |+----+--- 阅读全文