功能要求如下:
select card.cardNo,date_format(openDate,'%Y年%m月%d日'),money,password,isLock,card.userId from card
select id,date_format(transDate,'%Y年%m月%d日'),transinfo.cardNo,type,money,remark from transinfo
select *, time_format(transDate,'%H:%i:%s') c from transinfo order by c
select *, time_format(transDate,'%H:%i:%s') c from transinfo where time_format(transDate,'%H:%i:%s') between '06:00:00' and '19:00:00'
select id,date_format(transDate,'%Y-%m-%d'),transinfo.cardNo,type,money,remark from transinfo where date_format(transDate,'%Y-%m-%d') between str_to_Date('06/20/2019','%m/%d/%Y') and str_to_Date('07/20/2019','%m/%d/%Y')
select openDate ,date_format(transDate,'%Y-%m-%d') from transinfo, card where transinfo.cardNo=card.cardNo and (Datediff(date_format(transDate,'%Y-%m-%d'), openDate))/30>3
-- 查询每个客户的银行卡号,展示客户名称,银行卡号两个值,多张银行卡使用逗号分隔展示
select name, group_concat(cardNo) from user left join card on user.userld=card.userId group by name