文章目录
1.通过文件名查表
mysql> show tables;
+--------------------+
| Tables_in_students |
+--------------------+
| class |
+--------------------+
1 row in set (0.00 sec)
mysql> SELECT FILE FROM `sys`.`io_global_by_file_by_bytes` WHERE FILE REGEXP DATABASE();
+-----------------------------------+
| file |
+-----------------------------------+
| @@basedir/data/students/class.ibd |
+-----------------------------------+