목요일, 1월 16, 2025
HomeLinuxmysql Index column size too large the maximum column size is 767...

mysql Index column size too large the maximum column size is 767 bytes.

mysql Index column size too large the maximum column size is 767 bytes.

/etc/mysql/my.cnf

innodb_large_prefix = ON
innodb_file_format = BARRACUDA

위와 같이 적용후

CREATE TABLE 생성 SQL문 작성시 ROW_FORMAT=DYNAMIC 추가

CREATE TABLE `dpl_rel_info` (
  `DEPLOY_SN` varchar(50) NOT NULL COMMENT '순번',
  `REQUEST_SN` varchar(50) NOT NULL,
  `FILE_PATH` varchar(400) NOT NULL COMMENT  '경로',
  `REVISION` varchar(100) NOT NULL COMMENT '리비전',
  `COMMENT` varchar(4000) DEFAULT NULL COMMENT '메시지',
  `MERGE_RESULT` varchar(100) DEFAULT NULL COMMENT '결과',
  `REGIST_ID` varchar(30) NOT NULL COMMENT '등록자',
  `REGIST_DATE` datetime NOT NULL COMMENT '등록일',
  `MODIFY_ID` varchar(30) NOT NULL COMMENT '수정자',
  `MODIFY_DATE` datetime NOT NULL COMMENT '수정일',
  PRIMARY KEY (`DEPLOY_SN`,`FILE_PATH`,`REVISION`,`REQUEST_SN`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='연결정보' ROW_FORMAT=DYNAMIC;

 

RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Most Popular