Database information_schema - table KEY_COLUMN_USAGE

MySQL returned an empty result set (i.e. zero rows).

SQL-query : [Edit]
SELECT * FROM `KEY_COLUMN_USAGE` LIMIT 0, 30

[ Browse ] [ Select ] [ Insert ] [ Empty ]

Field	Type	Attributes	Null	Default	Extra	Action
CONSTRAINT_CATALOG	varchar(512)		Yes	NULL		Change	Drop	Primary	Index	Unique
CONSTRAINT_SCHEMA	varchar(64)		Yes			Change	Drop	Primary	Index	Unique
CONSTRAINT_NAME	varchar(64)		Yes			Change	Drop	Primary	Index	Unique
TABLE_CATALOG	varchar(512)		Yes	NULL		Change	Drop	Primary	Index	Unique
TABLE_SCHEMA	varchar(64)		Yes			Change	Drop	Primary	Index	Unique
TABLE_NAME	varchar(64)		Yes			Change	Drop	Primary	Index	Unique
COLUMN_NAME	varchar(64)		Yes			Change	Drop	Primary	Index	Unique
ORDINAL_POSITION	bigint(10)		Yes	0		Change	Drop	Primary	Index	Unique
POSITION_IN_UNIQUE_CONSTRAINT	bigint(10)		Yes	NULL		Change	Drop	Primary	Index	Unique
REFERENCED_TABLE_SCHEMA	varchar(64)		Yes	NULL		Change	Drop	Primary	Index	Unique
REFERENCED_TABLE_NAME	varchar(64)		Yes	NULL		Change	Drop	Primary	Index	Unique
REFERENCED_COLUMN_NAME	varchar(64)		Yes	NULL		Change	Drop	Primary	Index	Unique

Print view
Run SQL query/queries on database information_schema [Documentation] :

SELECT * FROM `KEY_COLUMN_USAGE` WHERE 1
Show this query here again
Browse - Select - Insert - Empty
Add new field :
Alter table order by : (singly)
Insert textfiles into table

View dump (schema) of table

Structure only Structure and data Data only CSV for Ms Excel data CSV data : Fields terminated by Fields enclosed by Fields escaped by Lines terminated by	Add 'drop table' Complete inserts Extended inserts Use backquotes with tables and fields' names Send ( "gzipped" "bzipped" )
Data : Offset -- No. Of records

Table comments :
Table type :
Drop table KEY_COLUMN_USAGE