SELECT cardNo,date_format(openDate,'%Y年%m月%d日'),money,userId FROM card SELECT id,date_format(transDate,'%Y年%m月%d日'),cardNo,type,money,remark FROM transinfo SELECT id,transDate,cardNo,type,money,remark FROM transinfo ORDER BY HOUR(transDate),MINUTE(transDate),SECOND(transDate) SELECT id,transDate,cardNo,type,money,remark FROM transinfo WHERE HOUR(transDate)>='19:00:00' or HOUR(transDate)<='06:00:00'
SELECT id,date_format(transDate,'%d/%m/%Y') ,cardNo,type,money,remark FROM transinfo WHERE transDate>'06/20/2019' or transDate<'07/20/2019'
SELECT * FROM card c,transinfo t WHERE c.cardNo=t.cardNo and month(transDate)-3>month(openDate)
SELECT name,GROUP_CONCAT(cardNo) cardNo FROM user u,card c WHERE u.userId=c.userId GROUP BY name