Shulou(Shulou.com)05/31 Report--

This article mainly introduces the relevant knowledge of "how mysql queries the field names of tables". The editor shows you the operation process through actual cases. The operation method is simple, fast and practical. I hope this article "how to query the field names of mysql tables" can help you solve the problem.

In mysql, you can query the field names of a table with the statement "SELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'database name' AND TABLE_NAME = 'table name'".

The operating environment of this tutorial: windows10 system, mysql8.0.22 version, Dell G3 computer.

How does mysql query the field name of a table

Use the following statement to query:

Select COLUMN_NAME from information_schema.COLUMNS where table_name = 'your_table_name'

There is a problem with the above approach. If the table name you want to query exists in multiple databases, the result of the query will include all the field information.

In MySQL, you can use SELECT statements to query data. Query data refers to the use of different query methods to obtain different data from the database according to the requirements, which is the most frequent and important operation.

Information_schema, which stores information about all databases (such as table names, column names, corresponding permissions, etc.)

You can see from DESC information_schema.COLUMNS that the column name TABLE_SCHEMA in the table is the name of the record database, so the following is more stringent

Add database name

SELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'database name' AND TABLE_NAME = 'table name'

The result displayed in the visualization tool MySQL Workbench is similar to the following:

This is the end of the introduction to "how mysql queries the field names of tables". Thank you for reading. If you want to know more about the industry, you can follow the industry information channel. The editor will update different knowledge points for you every day.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.