MySQL searches for field names through field annotations
Sometimes there are too many fields in the MySQL 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
-------------------------------------- Split line --------------------------------------
Install MySQL in Ubuntu 14.04
MySQL authoritative guide (original book version 2nd) Clear Chinese scan PDF
Ubuntu 14.04 LTS install LNMP Nginx \ PHP5 (PHP-FPM) \ MySQL
Build a MySQL Master/Slave server in Ubuntu 14.04
Build a highly available distributed MySQL cluster using Ubuntu 12.04 LTS
Install MySQL5.6 and Python-MySQLdb in the source code of Ubuntu 12.04
MySQL-5.5.38 universal binary Installation
-------------------------------------- Split line --------------------------------------
This article permanently updates the link address: