mysql数据库怎么查找某张表被哪些视图引用？

Question

mysql数据库怎么查找某张表被哪些视图引用？请各位出来解答，thanks

Answer 1

SELECT 
    TABLE_NAME,
    REFERENCED_TABLE_NAME,
    REFERENCED_VIEW_NAME,
    TABLE_SCHEMA,
    VIEW_DEFINITION
FROM 
    information_schema.VIEWS
WHERE 
    VIEW_DEFINITION LIKE '%table_name%'