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的列