How can we use MySQL ALTER TABLE command for adding comments on columns?

We can use ‘COMMENT’ keyword with ALTER TABLE command while modifying the column to add comments on columns. For example if we want to add comment in column ‘id’ of table ‘testing’ then following query will do it −

mysql> ALTER TABLE testing MODIFY id INT COMMENT 'id of employees';
Query OK, 0 rows affected (0.07 sec)
Records: 0 Duplicates: 0 Warnings: 0

With following query it can be checked in the comment field of a column.

mysql> Show full columns from testing\G
*************************** 1. row ***************************
     Field: id
      Type: int(11)
 Collation: NULL
      Null: NO
       Key: PRI
   Default: 0
     Extra:
Privileges: select,insert,update,references
   Comment: id of employees
*************************** 2. row ***************************
     Field: Name
      Type: varchar(20)
 Collation: latin1_swedish_ci
      Null: YES
       Key:
   Default: NULL
     Extra:
Privileges: select,insert,update,references
   Comment:
2 rows in set (0.05 sec)

Anjana

Published on 19-Feb-2018 10:02:08

• Related Questions & Answers
• How can we alter table to add MySQL virtual GENERATED COLUMNS?
• How can we alter table to add MySQL stored GENERATED COLUMNS?
• Can we alter order of columns in MySQL?
• ALTER table by adding AUTOINCREMENT in MySQL?
• Adding unique constraint to ALTER TABLE in MySQL
• Set auto increment initial value for MySQL table using ALTER command
• How can we add multiple columns, with single command, to an existing MySQL table?
• What MySQL returns when we remove all the columns from a table by using ALTER TABLE command with DROP keyword?
• How can we set PRIMARY KEY on multiple columns of a MySQL table?
• How can we put comments in a column of existing MySQL table?
• Can we use the word user for a MySQL table?
• How can we alter a MySQL stored procedure?
• How can we alter a MySQL stored function?
• Can we use ADD and CHANGE with ALTER Statement in MySQL?
• How can we set PRIMARY KEY on multiple columns of an existing MySQL table?