1
2
3
4
|
CREATE TABLE groups( gid INT PRIMARY KEY AUTO_INCREMENT COMMENT '设置主键自增' , gname VARCHAR (200) COMMENT '列注释' , ) COMMENT= '表注释' |
2修改已创建了的表注释
1
2
|
ALTER TABLE groups COMMENT '修改表注释' ALTER TABLE groups MODIFY COLUMN gname VARCHAR (100) COMMENT '修改列注释' |
3查看表注释 ( 我喜欢用第二个 )
1
|
SHOW CREATE TABLE communication_group |
或
1
|
SELECT table_name,table_comment FROM information_schema.tables WHERE table_schema = '所在的db' AND table_name = '表名groups' |
4查看列注释 ( 我喜欢用第一个 )
1
2
3
|
SHOW FULL COLUMNS FROM groups -- 这个可以按条件的去搜索某名字或某数据类型的列的信息:例如 SHOW FULL COLUMNS FROM tableName WHERE FIELD = 'add_time' OR TYPE LIKE '%date%' -- 查看tableName表中列名是add_time的或类型是date的列 |
或
1
|
SELECT column_name, column_comment FROM information_schema.columns WHERE table_schema = 'db' AND table_name = 'groups' |