楼主你好,MySQL的结果没有这样分层次显示的效果,你这样只能单独显示,如下:
select pro_name,name,fee from tb_xx where pro_name='电脑'
select pro_name,name,fee from tb_xx where pro_name='耗材'
select pro_name,name,fee from tb_xx where pro_name='办公用品'
楼主你好,MySqL的结果没有这样分层的结果,他只能取出记录
建议如此:
select name,fee from tb_xx where pro_name='电脑'
select name,fee from tb_xx where pro_name='耗材'
select name,fee from tb_xx where pro_name='办公用品'