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合并字段
最新推荐文章于 2024-07-14 02:05:19 发布