[MySQL]MySQL timestamp형 컬럼에 기본값 설정

CREATE TABLE `BOARD_BASIC_DATA` 
(
`NO` INT(5) NULL AUTO_INCREMENT
, `TITLE` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
, `CONTENT` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
, `WRITER` VARCHAR(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
, `INSERT_DT` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00'
, `UPDATE_DT` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
, PRIMARY KEY (`NO`)
) ENGINE = InnoDB CHARSET=utf8 COLLATE utf8_general_ci;


INSERT INTO `BOARD_BASIC_DATA` (TITLE, CONTENT, WRITER, INSERT_DT, UPDATE_DT)
VALUES ('TITLE', 'CONTENT', 'WRITER', NULL, NULL);

NULL을 입력해줘야 한다.