mysql中int转varchar

这里要注意，cast(XX as varcahr(10))在mysql中不好使，要cast(XX as char(10))这样才好使