sql中将字符串数字转换成数字:方法一:SELECT CAST('123' AS SIGNED integer);方法二:SELECT CONVERT('123',SIGNED);方法三:SELECT '123'+0; 首先char型别的必须是数字 convert(int,[char型别的栏位名])MySQL语句转换成Oracle的SQL语句 CREATE TABLE stu_score_ms.course (cid char(10) collate utf8_bin ...