找出 xnc数据库中,列的名字是origin的地方。
SELECT
*
FROM
information_schema.`COLUMNS` c
WHERE
c.TABLE_SCHEMA = 'xnc'
AND c.COLUMN_NAME = 'origin'
找出 xnc数据库中,引用user表的id作为外键的地方。
SELECT
*
FROM
information_schema.KEY_COLUMN_USAGE c
WHERE
c.REFERENCED_TABLE_SCHEMA = 'xnc'
AND c.REFERENCED_TABLE_NAME = 'user'
AND c.REFERENCED_COLUMN_NAME = 'id'