Base: MySQL table field comments: description vs column description

asked 2016-11-04 22:18:54 +0200

EasyTrieve gravatar image

updated 2016-11-05 03:14:37 +0200

When editing a table's design, depending on which database you are using or connected to, in addition to field name and type, you have one or more places for a field comment, as follows:

  • If you are using the built in HSQLDB then you have Description.

  • If you are connecting to MySQL then you have two comment fields: Description and Column Description.

Using PHPMyAdmin I can see that Column Description is used for the official SQL field comment.

So why have both comment fields? Wouldn't it make sense to have just Description and use it for the SQL comment?

Is there some other reason or usage that requires two comments for a field?

edit retag flag offensive close merge delete