多表联合查询 查询 需要的字段
"select a.ID,a.TypeID,a.CdKey,a.RewardList,b.CpsIds,a.ExpiredTime,b.IsEnabled,b.IsPublic,b.TypeName from Activity_RedeemCode a inner join Activity_RedeemCode_Type b ON a.TypeID = b.TypeID where a.CdKey =? and a.States = 1", cdKey
插入某条数据
"insert into Activity_RedeemCode_User (TicketID,UserID,CpsID)values(?,?,?)"
获得当天的数据 我的一句sql是这样写的
select * from Activity_RedeemCode_User where TicketId = ? and UserID = ? AND DATE_FORMAT(UseTime,'%Y-%m-%d') = DATE_FORMAT(NOW(),'%Y-%m-%d')