select IFNULL((select cm_id from class_management where cm_name = "训码科技2019软件0班"),0) cm_id;