MySql中String转int SELECT CAST('123' AS SIGNED); SELECT CONVERT('123',SIGNED); SELECT '123'+0; 引用 https://blog.csdn.net/er_shao_ye/article/details/50987994