mysql - 在使用 Mysql cast 函数获取检查 Mysql 版本或正确的语法错误时

Question

SELECT EM.rec_id AS rec_id,EM.employee_code, EM.employee_name, EM.designation,   EM.weekly_off_day, EM.gender, EM.payment_type, SM.shift_name, PM.plant_name, EM.status AS status,EM.settlement_no,
    SCM.section_name
    FROM employee_master AS EM 
    INNER JOIN shift_master AS SM ON EM.shift_rec_id = SM.rec_id 
    INNER JOIN section_master AS SCM ON EM.section_rec_id = SCM.rec_id 
    INNER JOIN plant_master AS PM ON EM.plant_rec_id = PM.rec_id
    ORDER BY CAST(EM.employee_code As INT) 

这是我正在使用的sql。谢谢

Answer 1

SELECT EM.rec_id AS rec_id,EM.employee_code, EM.employee_name, EM.designation,   EM.weekly_off_day, EM.gender, EM.payment_type, SM.shift_name, PM.plant_name, EM.status AS status,EM.settlement_no,
    SCM.section_name
    FROM employee_master AS EM 
    INNER JOIN shift_master AS SM ON EM.shift_rec_id = SM.rec_id 
    INNER JOIN section_master AS SCM ON EM.section_rec_id = SCM.rec_id 
    INNER JOIN plant_master AS PM ON EM.plant_rec_id = PM.rec_id
    ORDER BY CAST(EM.employee_code As UNSIGNED ) 

参见 this所以线程