摘要： FROM :http://bbs.csdn.net/topics/380025779mysql> select * from test1+------+-------+-------+| sbid | Ename | type |+------+-------+-------+| JS.1 | 甲1 | 厂家2 || JS.2 | 甲2 | 厂家1 || JS.3 | 甲3 | 厂家1 || JS.4 | 甲4 | 厂家2 || JS.5 | 乙1 | 厂家2 || HN.3 | 乙3 | 厂家1 || HN.4 | 乙8 | 厂家1 |+------+-----... 阅读全文