完成以下功能;
select lower(ename) from user ;
select concat( name,',', ename)from user;
select transinfo.* from user,card, transinfo where locate('1992',personId)!=0 AND `user`.userId=card.userId and card.cardNo=transinfo.cardNo
select left(name,1) l,count(card.userId) from user,card where user.userId=card.userId GROUP BY l;
select * from user where length(name)=6;
select name,concat('【',SUBSTR(personId,7,4),'-',substring(personId,11,2),'-',substring(personId,13,2),'】') from user