Mike Paradis
asked on
Strange result after an information_schema query
Doing some work on a MySQL DB I found that a simple query like the following:
Is there any acceptable explanation for this?
select
table_name
from
information_schema.KEY_COLUMN_USAGE
where
table_schema = 'db-name'
and referenced_table_name = 'table';
was showing a list like the following: table_name
sql.php?table=table-one&token=3d38d6f1a9fc11efb91793b8d6745f04
sql.php?table=table-two&token=3d38d6f1a9fc11efb91793b8d6745f04
sql.php?table=table-three&token=3d38d6f1a9fc11efb91793b8d6745f04
instead of a simple list of the tables referenced by the table "table" like this: table_name
table-one
table-two
table-three
Is there any acceptable explanation for this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If not applied, try applying the latest patches and check it out once..