/SQL/Mysql show table column comments sql

Mysql show table column comments sql

Mysql show table column comments sql

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

2

Source: dev.mysql.com

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'

0

Source: stackoverflow.com

Similar codes

0 vote179 views1 answer
How to open mysql in docker
SQL
0 vote166 views1 answer
Criteria builder select subset of column
SQL
0 vote189 views2 answers
Generate sql trigger through ef migration
SQL
0 vote177 views1 answer
How to take sum of column with same id and different table in SQL?
SQL
3 votes176 views1 answer
Set default today mysql
SQL
0 vote214 views1 answer
How to check rollback status in oracle
SQL
2 votes161 views1 answer
Sql server check for value in multiple columns
SQL
0 vote173 views1 answer
Oracle DROP PROGRAM
SQL
0 vote180 views1 answer
How to find sql server installation folder
SQL
0 vote187 views1 answer
The package java.sql is not accessible
SQL

Share