Mysql 게시판 테이블 생성, 조회, 등록, 수정, 삭제

-- 테이블 생성
CREATE TABLE `board` (
  `BOARD_NO` int NOT NULL AUTO_INCREMENT,
  `BOARD_TYPE` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `TITLE` varchar(100) DEFAULT NULL,
  `CONTENTS` varchar(500) DEFAULT NULL,
  `USER_ID` varchar(30) DEFAULT NULL,
  `CREATED_TIME` datetime DEFAULT now(),
  `UPDATED_TIME` datetime DEFAULT now(),
  `LIKES` int DEFAULT NULL,
  `COUNTS` int DEFAULT NULL,
  PRIMARY KEY (`BOARD_NO`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3;

-- 테이블 조회
SELECT BOARD_NO
     , BOARD_TYPE
     , TITLE
     , CONTENTS
     , USER_ID
     , CREATED_TIME
     , UPDATED_TIME
     , LIKES
     , COUNTS
FROM BOARD;

-- 테이블 등록
        INSERT INTO board
        (BOARD_TYPE
        , TITLE
        , CONTENTS
        , USER_ID
        , CREATED_TIME
        , UPDATED_TIME
        , LIKES
        , COUNTS)
        VALUES('게시판타입'
              , '제목'
              , '내용'
              , '사용자'
              , now()
              , now()
              , 0
              , 0);

-- 테이블 수정
        UPDATE board
        SET
            BOARD_TYPE = '게시판타입'
          , TITLE = '제목'
          , CONTENTS = '내용'
          , USER_ID = '사용자'
          , CREATED_TIME = now()
          , UPDATED_TIME = now()
          , LIKES = 0
          , COUNTS = 0
        WHERE
            BOARD_NO = '게시판번호';

-- 테이블 삭제
        DELETE
        FROM board
        WHERE BOARD_NO = '게시판번호'