mysql 创建表添加行、列注释

创建表添加注释

CREATE TABLE purchase(
                id int(25) PRIMARY KEY AUTO_INCREMENT, 
                user_id int(50) COMMENT'列注释',  
                created_on  datetime default NULL
            )ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='表注释';

查看表注释：

SELECT tableName,tableComment 
    FROM information_schema.tables 
    WHERE table_schema = '所在db' 
    AND table_name = '表名称';
或者：
SHOW CREATE TABLE purchase;

修改注释

ALTER TABLE purchase COMMENT '新的表注释';
ALTER TABLE purchase MODIFY COLUMN user_id VARCHAR(25) COMMENT '新的列注释';

查看列注释

SHOW FULL COLUMNS FROM purchase;
也可安条件查询
SHOW FULL COLUMNS FROM purchase 
    WHERE FIELD = 'user_id' 
    OR TYPE LIKE '%int%' 
-- 查看purchase表中列名是user_id的或类型是int的列