mysql comment syntax code example

Example 1: mysql comment

-- This is a SQL Comment

/* 
This is a multi-line
SQL comment 
*/

Example 2: 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'