Answers for "mysql show table column comments sql"

mysql show table column comments sql

/* mysql query for command line*/
SHOW FULL COLUMNS FROM "table_name";

Posted by: Guest on October-18-2021

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 "mysql show table column comments sql"