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
|
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'
|
1
|
SHOW
CREATE
TABLE
communication_group
|