GROUP_CONCAT超长截断问题
https://blog.csdn.net/CSDN_WYL2016/article/details/122778620
生成查询语句
SET SESSION group_concat_max_len = 10240;
SELECT
CONCAT(
'SELECT CONCAT_WS('','',',
GROUP_CONCAT(CONCAT(' IFNULL(CONCAT('''''''', `', COLUMN_NAME, '`, ''''''''), ''NULL'')')),
CONCAT(') FROM `', table_name, '`' ),
';'
)
FROM
information_schema.COLUMNS
WHERE
table_schema = 'tsc'
AND table_name = 'account_extend';
示例查询语句
SELECT CONCAT_WS(',', IFNULL(CONCAT('''', `Id`, ''''), 'NULL'), IFNULL(CONCAT('''', `PhoneNumber`, ''''), 'NULL'), IFNULL(CONCAT('''', `JobNumber`, ''''), 'NULL')) FROM `account_extend`;
网友评论