Mysql searches for the field name through field annotation, and mysql field annotation name

Mysql searches for the field name through field annotation, and mysql field annotation name

Sometimes there are too many fields in the table, just remember the table comment. To search for the field name through the field comment, you can use the following statement:

SELECT COLUMN_NAME, column_comment FROM INFORMATION_SCHEMA.Columns WHERE table_name = 'tj _ record 'AND table_schema = 'tianjin _ 000000' AND column_comment LIKE' % whether the data is valid %'

Table_schema indicates the database name. The query is as follows:

You can also search for comments by field name and use the preceding statement.

================ View the number of fields in the table: the desc tj_record syntax is: desc table name