2022-01-17 查询mysql数据库中所有表 包含视图： SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = '数据库名'; 不包含视图： SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = '数据库名' AND TABLE_TYPE = 'BASE TABLE';