테이블의 컬럼 조회 (코멘트 포함)
SHOW FULL COLUMNS FROM 테이블명
테이블 코멘트 설정
ALTER TABLE 테이블명 COMMENT = '코멘트'
CREATE TABLE 테이블명 (
컬럼1 INT,
) COMMENT = '코멘트'
컬럼 코멘트 설정
ALTER TABLE `테이블명` CHANGE COLUMN `컬럼명` `컬럼명` 데이터타입 NULL여부 DEFAULT값 EXTRA조건 COMMENT = '코멘트'
CREATE TABLE 테이블명 (
컬럼1 INT,
) COMMENT = '코멘트';
ex)
ALTER TABLE `cm_db`.`master_employee_log`
CHANGE COLUMN `seq` `seq` BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT 'Sequence (PK)1' ,
CHANGE COLUMN `emp_id` `emp_id` VARCHAR(20) NULL DEFAULT NULL COMMENT 'employee ID (PK)1' ,
CHANGE COLUMN `user_id` `user_id` VARCHAR(20) NULL DEFAULT NULL COMMENT 'User ID1' ,
CHANGE COLUMN `company_id` `company_id` VARCHAR(20) NULL DEFAULT NULL COMMENT 'Company ID1' ,
CHANGE COLUMN `department_id` `department_id` VARCHAR(20) NOT NULL COMMENT 'Department ID1' ,
CHANGE COLUMN `job_code` `job_code` VARCHAR(20) NULL DEFAULT NULL COMMENT 'Job Code1' ,
CHANGE COLUMN `first_name` `first_name` VARCHAR(50) NULL DEFAULT NULL COMMENT '2' ,
CHANGE COLUMN `last_name` `last_name` VARCHAR(50) NULL DEFAULT NULL COMMENT '3' ,
CHANGE COLUMN `middle_name` `middle_name` VARCHAR(100) NULL DEFAULT NULL COMMENT '4' ,
CHANGE COLUMN `display_name` `display_name` VARCHAR(100) NULL DEFAULT NULL COMMENT '5' ,
CHANGE COLUMN `tel_no` `tel_no` VARCHAR(30) NULL DEFAULT NULL COMMENT '6' ,
CHANGE COLUMN `mobile_no` `mobile_no` VARCHAR(30) NULL DEFAULT NULL COMMENT '7' ,
CHANGE COLUMN `email_address` `email_address` VARCHAR(50) NULL DEFAULT NULL COMMENT '8' ,
CHANGE COLUMN `set_email_alarm` `set_email_alarm` CHAR(1) NOT NULL DEFAULT 'Y' COMMENT '9' ,
CHANGE COLUMN `create_date` `create_date` DATETIME NOT NULL COMMENT 'DATE 1' ,
CHANGE COLUMN `update_date` `update_date` DATETIME NULL DEFAULT NULL COMMENT 'DATE 2' ,
CHANGE COLUMN `fail_count` `fail_count` INT(11) NULL DEFAULT '0' COMMENT '123' ,
CHANGE COLUMN `business_day_id` `business_day_id` INT(11) NULL DEFAULT NULL COMMENT '2323' ,
CHANGE COLUMN `business_hour_id` `business_hour_id` INT(11) NULL DEFAULT NULL COMMENT '123123' ;
*참고자료 (MySql Workbench 에서 Tool 을 이용해 ALTER COLUMN 하는 방법)
: 한땀 한땀 작성하고 실행해야하는지라 추천하지 않는다.
https://dataedo.com/kb/tools/mysql-workbench/how-to-view-and-edit-table-and-column-comments
How to view and edit table and column comments with MySQL Workbench - MySQL Workbench Tutorials
MySQL, like most databases, allows you to add comments to each table and column. If used, this is useful for understanding database schema and meaning of data elements.
dataedo.com