Querying MySQL data table for field names and table structures

Query the fields of the table:

--Query the field name of the tableSELECTcolumn_name--Group_concat (' A. ', column_name) as column_name--Add table aliases and connect with commas frominformation_schema. COLUMNSWHERETable_schema= 'Hera' --Database name andtable_name= 'Tbn_car' --Table name;

Query table structure:

--query Table StructureSELECTtable_name as 'Table name', column_name as 'Field name', Column_type as 'type', Column_key as 'PRIMARY Key', Column_comment as 'Description' frominformation_schema. COLUMNSWHERETable_schema= 'Hera' --Database name andtable_name= 'Tbn_car' --Table name;

.

Querying MySQL data table for field names and table structures