MYSQL ParseException line 2:833 mismatched input ‘；‘ expecting ) near ‘“景区) comment “‘ in create tab

错误：ParseException line 2:833 mismatched input ';' expecting ) near '"景区) comment "' in create table statement

字段太多了，用了group_concat超过23个字段就报错

SHOW VARIABLES LIKE 'group_concat_max_len'; 

修改group_concat_max_len = 102400

重启MySQL

临时生效办法：

SET GLOBAL group_concat_max_len = 102400;

SET SESSION group_concat_max_len = 102400;