mysql 1024个字段建表配制

DROP table if EXISTS ms_mdate;
SET SESSION innodb_strict_mode = OFF;
select concat(‘create table ms_mdate (ceqcode varchar(50),ceqtype varchar(10),’,GROUP_CONCAT(‘`’,dt2,’`’,’ varchar(10)’),’) DEFAULT CHARSET=utf8′) into @abc from ms_dim_day where s_mode=2;
#select @abc;
PREPARE stmt1 FROM @abc;
EXECUTE stmt1;
DEALLOCATE PREPARE stmt1;