/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

103 votes2.4K views1 answer
Like sql
SQL
8 votes244 views1 answer
Mysql dump restore
SQL
0 vote203 views1 answer
Oracle winter time change
SQL
6 votes186 views2 answers
If not exists insert sql
SQL
6 votes253 views3 answers
Rename column ORACLE
SQL
0 vote143 views1 answer
Procedures and functions in pl/sql
SQL
0 vote183 views1 answer
Back up stored procedures mysql
SQL
0 vote199 views1 answer
Mysql range of dates overlap
SQL
2 votes220 views1 answer
Oracle kill session by sql_id
SQL
0 vote204 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL

Share