MYSQL database name, table name, field name query

Query all fields of all tables:

Select *  from WHERE table_name='sys_users'

Effect:

Query all fields of the specified table:

Select *  from WHERE table_name='sys_users' and Table_schema= ' Taoke '

Effect:

Query the specified type of all fields of the specified table, note:

Query All tables that contain this field name:

SELECT *  from WHERE column_name='name';

Query the table that contains this field name for the specified database:

SELECT *  from WHERE column_name='name' and Table_schema='  wljdb';

Querying all fields of a specified table in a specified table database

Select  from WHERE table_name='sys_users' and Table_schema=  'taoke'

Queries the specified table database for the second field name of the specified table:

Select  from WHERE table_name='sys_users' and Table_schema=  'taoke'1,1

Above, extrapolate

---------------------finished----------------------------

MySQL permissions Grant

Http://www.cnblogs.com/Richardzhu/p/3318595.html

MYSQL database name, table name, field name query