11.12.6 CAST(value AS type)函数
CAST(value AS type)函数将value转换为type类型的值,其中type的取值如表11-6所示。
表11-6 CAST(value AS type)函数中type可取的值
![](https://img-service.csdnimg.cn/img_convert/95a19df61ac14aa7974867e4f6b71630.jpg?x-oss-process=image/watermark,text_ZG1mZW5vd2JlaWppbmc,color_FFFFFF,size_16,shadow_100,t_100,g_se,order_0,align_2,interval_4)
使用示例如下:
mysql> SELECT CAST('123' AS SIGNED);
+-----------------------+
| CAST('123' AS SIGNED) |
+-----------------------+
| 123 |
+-----------------------+
1 row in set (0.00 sec)
CONVERT(value,type)函数的作用与CAST(value AS type)函数相同,不再赘述。