Answers for "added comment to entire table mysql"

mysql add comment to column

ALTER TABLE `user` CHANGE `id` `id` INT( 11 ) COMMENT 'id of user';

Posted by: Guest on September-16-2020

mysql, how to query the table comments?

SELECT a.COLUMN_NAME, a.COLUMN_COMMENT
FROM  information_schema.COLUMNS a 
WHERE a.TABLE_NAME = 'YOUR_TABLE_NAME'

Posted by: Guest on April-27-2021

Code answers related to "added comment to entire table mysql"