create table a ( id int not null, FileName varchar(100) not null )
insert into a values(1,'010101') insert into a values(2,'100010 ') insert into a values(3,'111100')
譬如:输入一个 FileName的值为 010101 --->>b;d;f
如: select funs('010101') from a; /** b;d;f */
funs这个函数要求帮忙的..谢谢 要求写一个函数 长度是固定的不？ SQL code: case when substing(FileName,1,1)=0 then '' else 'a' end +';'+ case when substing(FileName,2,1)=0 then '' else 'b' end +';'+ case when substing(FileName,3,1)=0 then '' else 'c' end +';'+ ......
select o_customer,o_price from orders having o_price >=avg(o_price) select o_customer,o_price from orders where o_price >=(select avg(o_price) from orders) 我感觉没有区别啊，怎么在mysql会有 ......
