SELECT * FROM information_schema.TABLES where TABLE_SCHEMA = (select database()) and table_type = 'BASE TABLE';
这里需要注意多schema和视图
SELECT * FROM information_schema.TABLES where TABLE_SCHEMA = (select database()) and table_type = 'BASE TABLE';
这里需要注意多schema和视图