mysql数据类型转换函数_MySQL数据类型转换函数CAST与CONVERT的用法

SELECT s.supplier_id AS supplierId ,s.main_products AS mainProducts

,s.group_id AS groupId,s.head_url AS supplierHead,

s.repair_center_name AS repairCenterName,s.shop_url AS shopUrl

,s.manager_phone AS managerPhone, s.service_tel AS serviceTel,

s.pro_name AS proName ,s.city_name AS cityName ,s.area_name AS

areaName ,s.detailed ,shop_profile AS shopProfile,s.company AS

supplierName,s.head_url AS headUrl

FROM w_supplier_sort w

LEFT JOIN s_supplier s ON w.supplier_id = s.supplier_id

LEFT JOIN s_user u ON w.supplier_id = u.id

WHERE s.city_number = #{cityNumber,jdbcType=VARCHAR} AND

UNIX_TIMESTAMP(NOW())*1000 < s.end_time

AND s.main_products is not NULL AND u.user_state = 0 AND u.account_state = 0

ORDER BY convert((sell_number /#{sellSum,jdbcType=BIGINT} * #{sellFaciend,jdbcType=DECIMAL} +

call_number/#{callSum,jdbcType=BIGINT} * #{callFaciend,jdbcType=DECIMAL}),decimal(18,10))

DESC