56,678
社区成员
发帖
与我相关
我的任务
分享
SELECT CONVERT(CONCAT_WS('~',ID,ADDRESS,xxx1,xxx2,xxx3,xxx4,xxx5...) , char(1000))FROM TABLE;
SELECT CONVERT(CONCAT_WS('~',ID,ADDRESS,xxx1,xxx2,xxx3,xxx4,xxx5...) , char(200))FROM TABLE;
SELECT CAST(CONCAT_WS('~',ID,ADDRESS,xxx1,xxx2,xxx3,xxx4,xxx5...) AS CHAR(10000) CHARACTER SET utf8)FROM TABLE;