功能要求如下:
select card.*,date_format(openDate,'%Y年%m月%d日') 开卡日期 from card;
select transDate, date_format(transDate,'%Y年%m月%d日') from transinfo;
select transinfo.* from transinfo order by date_format(transDate,'%H:%i:%s');
select transinfo.* from transinfo WHERE date_format(transDate,'%H:%i:%s') not between '06:00:00' and '19:00:00';
select transinfo.*from transinfo where transDate between str_to_date('06/20/2019','%m/%d/%Y') and str_to_date('07/20/2019','%m/%d/%Y');
select card.* from card ,transinfo where transDate not between openDate and date_add(openDate,interval 3 month) and card.cardNo=transinfo.cardNo;
select name,group_concat(cardNo) from card,user where user.userId=card.userId GROUP BY name;