mysql:表属性的文档

Question

有没有办法在 mysql 中将文档/注释附加到表和属性？

能够像记录类属性一样记录数据库属性是很自然的事情。

Answer 1

是的，你可以add comments到 MySQL 中的列:

alter table pancakes change house house int comment 'where is?'

然后您可以使用 show full columns 查看它们:

The FULL keyword causes the output to include the column collation and comments, as well as the privileges you have for each column.

评论是fairly spacious now , 他们曾经是 pretty small :

A comment for a column can be specified with the COMMENT option, up to 1024 characters long.