extract_table_from_file_name

This function extracts and returns the table name from a given file path, determined solely by parsing the path string.

Sys Schema is available from MariaDB 10.6.

Syntax

sys.extract_table_from_file_name(path)

Description

extract_table_from_file_name is a stored function available with the Sys Schema.

Given a file path, it returns the table name.

The function does not examine anything on disk. The return value, a VARCHAR(64), is determined solely from the provided path.

Examples

SELECT sys.extract_table_from_file_name('/usr/local/mysql/data/db/t1.ibd');
+---------------------------------------------------------------------+
| sys.extract_table_from_file_name('/usr/local/mysql/data/db/t1.ibd') |
+---------------------------------------------------------------------+
| t1                                                                  |
+---------------------------------------------------------------------+

See also

• extract_schema_from_file_name()

_{This page is licensed: CC BY-SA / Gnu FDL}