Question

mysql中int型的数字怎么转换成字符串

Answer 1

mysql中int型的数字怎么转换成字符串

1
2
3
4
5

-- 请叫我红领巾，不要问我为什么，有才就是这么任性
/* 比如将123转换为char类型 */
SELECT <a href="https://www.baidu.com/s?wd=CAST&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1Y4uH6vPHnzrH6dPAF9Pvc10ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3EnHmsPHf3rj0sPW61nHc1rHn3Ps" target="_blank" class="baidu-highlight">CAST</a>(123 AS CHAR);
/* 或者使用concat方法 */
SELECT CONCAT(123,'');

Answer 2

mysql中int型的数字怎么转换成字符串
/* 比如将123转换为char类型 */
SELECT <a href="https://www.baidu.com/s?wd=CAST&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1d9mywWPjn4uH9bnAu-ryPB0ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3EnHmsPHf3rj0sPW61nHc1rHn3Ps" target="_blank" class="baidu-highlight">CAST</a>(123 AS CHAR);
/* 或者使用concat方法 */
SELECT CONCAT(123,'');

Answer 3

alert table ...

哈哈忘了，你查一下吧，语法修改字段的

Answer 4

concat("", 1234)