mysql语句解析二进制字段内容为数字

原创
小哥 2年前 (2023-05-23) 阅读数 36 #大杂烩

SELECT  id,
CONCAT(point(,
conv(
CONCAT(mid(cast(hex(data) as char),7, 2),
mid(cast(hex(data) as char),5, 2),
mid(cast(hex(data) as char),3, 2),
mid(cast(hex(data) as char),1, 2)),
16,10)/1000000,
,,
conv(
CONCAT(mid(cast(hex(data) as char),15, 2),
mid(cast(hex(data) as char),13, 2),
mid(cast(hex(data) as char),11, 2),
mid(cast(hex(data) as char),9, 2)),16,10)/1000000,
)) AS point  from m_position WHERE id = 123

结果示例:

123, point(115.149722,5.005278)

版权声明

所有资源都来源于爬虫采集,如有侵权请联系我们,我们将立即删除

热门