摘要:
-- ORDER_TIME datetime NOT NULL(字段类型)SELECTso.`ID`,so.`ORDER_TIME`,NOW(),CONCAT(ROUND(TIMESTAMPDIFF(MINUTE,so.`ORDER_TIME`,NOW())/60,1),'') AS hourLat 阅读全文
摘要:
-- DESC 降序时候默认null值排在后面、ASC升序时默认null值排在前面,可使用 IS NULL处理 ORDER BY score desc,gmPrice IS NULL,gmPrice,avg_time IS NULL,avg_time 阅读全文
摘要:
-- in_date datetime NULLDATE_FORMAT(ls.`in_date`,'%Y-%m-%d %T')AS create_time 阅读全文