后端时间戳转换



SELECT t1.*,COUNT(distinct t2.mId)'countCollection',COUNT(distinct t3.mId)'countLike',t4.model,
t5.per_picture,t5.mId'detailsMID',t5.id'detailsID',DATE_FORMAT(t5.details_time,'%Y-%m-%d %H:%i:%S') as time,t5.commodity_picture,t5.commodity_http 
FROM t_card t1 
LEFT JOIN t_card_collection t2 ON t1.id=t2.cardId 
LEFT JOIN t_card_like t3 ON t1.id=t3.card_id 
LEFT JOIN t_card_model t4 ON t4.id=t1.themeId 
LEFT JOIN t_card_details t5 ON t1.mId=t5.mId 
WHERE t1.id=7
已标记关键词 清除标记
相关推荐
©️2020 CSDN 皮肤主题: 大白 设计师:CSDN官方博客 返回首页