oracle中的to_number在mysql中的转换 select cast(11 as unsigned int) /*整型*/select cast(11 as decimal(10,2)) /*浮点型*/注:(10,2)代表数字共十位,小数点后两位。