Answers for "mysql, how to query the table comments?"

SQL
0

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
0

comments in mysql

#this is a comment
-- this is a comment but requires a whitespace/tab/newline after the double -
Posted by: Guest on December-26-2020

Code answers related to "mysql, how to query the table comments?"

Code answers related to "SQL"

Browse Popular Code Answers by Language