SELECT class_id,SUM(course_price) FROM (SELECT class_id,course_price,class_date,class_end_time, CONCAT(class_date,":",class_end_time) time_end FROM py_class_course
) pcc WHERE pcc.time_end>NOW() GROUP BY class_id
mysql合并字段
最新推荐文章于 2022-10-24 11:52:31 发布