How MySQL finds fields in a table

When developing a project, there is a feature that needs to see what tables are in the database, and what fields are available for each table, viewed online, and now shared with you.

Oracle:

Query data table (Tables) Name:
Select table_name, Tablespace_name
From Dba_tables
where tablespace_name = ' USERS ';
Field (Columns) name in Query data table (Tables):
Sql1:select column_name from All_tab_columns where table_name= ' table1 ';
Sql2:select column_name from User_tab_columns where table_name= ' table1 ';
Query Database (Databases) name

SQL Server:

Query Database (Databases) name:
SELECT name from master.dbo.sysdatabases WHERE status <> 512
Query data table (Tables) Name:
SELECT name from dbo.sysobjects WHERE objectproperty (id,n ' isusertable ') = 1 and name <> ' dtproperties '
Query the data table (Tables) name with schema:
SELECT b.name + '. ' + a.name as name from sysobjects a INNER joins Sys.schemas B on a.uid=b.schema_id WHERE objectproperty ( Id,n ' isusertable ') = 1 and a.name <> ' dtproperties '
Field (Columns) name in Query data table (Tables):

SELECT * from Dbo.syscolumns WHERE id=object_id (N ' [production].[ Product] ') ORDER by colid

Or

Select name from syscolumns Where id=object_id (' Tname ')

Mysql:

Query Database (Databases) name:
Show DATABASES/* This can see all the database names */
Query data table (Tables) Name:
Show TABLES/* can view all tables in the current database */
Field (Columns) name in Query data table (Tables):
Show columns form table name from database name
Or:
Show columns from database name. Table Name

Transfer from http://blog.csdn.net/cselmu9/article/details/8014655

How MySQL finds fields in a table