mysql 批量查询:mysql批量查询优化[朗读]

select*from表1where名字in('陈杰','陈','王洁','王兵')unionallselect*from表2where名字in('陈杰','陈','王洁','王兵')unionallselect*from表3where名字in('陈杰','陈','王洁','王兵')unionallselect*from表4where名字in('陈杰','陈','王洁','王兵')unionallselect*from表5where名字in('陈杰','陈','王洁','王兵')。