参考博客: https://www.cnblogs.com/chenqionghe/p/4675844.html
CAST(x AS type)
CONVERT(x,type)
这两个函数只对BINARY、CHAR、DATE、DATETIME、TIME、SIGNED INTEGER、UNSIGNED INTEGER。
SELECT CAST('123' AS UNSIGNED INTEGER) + 1 ->124 SELECT '123' + 1 ->124 其实MySQL能默认转换 SELECT CAST(NOW() AS DATE) ->2014-12-18
例如:
数据库中user表中 magicstr字段是16进制字符 转换成10进制 再被sha1编码
update sigma_account_us_user set `password`= SHA1(CONVERT( magicstr, SIGNED )) where id=467450