MySQL view column information in a table

View database and table names for all tables in all databases

SELECT '   TABLES '. ' Table_schema ', ' TABLES '. ' table_name 'from  ' information_schema '. ' TABLES ' 

View the database name and table name of all the base tables in all databases

SELECT '   TABLES '. ' Table_schema ', ' TABLES '. ' table_name 'from  ' information_schema '. ' TABLES 'WHERE  ='base table';

View all column information in the T1 table in the Test1 database

where order by ' ordinal_position ' refers to the order of the original columns in the table

  SELECT *  from    where ' table_schema ' = ' test1 ' and '    table_name '='t1'order by ' Ordinal_ POSITION ';

View table names and column names in all tables in the Test1 database

SELECT DISTINCT Table_name,column_name  from   where ' table_schema ' = ' test1 ';   

MySQL view column information in a table