在MySQL中,可以使用CAST
函數(shù)或CONVERT
函數(shù)來將數(shù)字轉(zhuǎn)換為字符串。
例如,要將一個(gè)數(shù)字列num
轉(zhuǎn)換為字符串列str_num
,可以使用以下語句:
CAST
函數(shù):SELECT CAST(num AS CHAR) AS str_num FROM table_name;
CONVERT
函數(shù):SELECT CONVERT(num, CHAR) AS str_num FROM table_name;
這樣就可以將數(shù)字列轉(zhuǎn)換為字符串列,方便在查詢結(jié)果中顯示或進(jìn)行其他操作。