1 of 1

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 available with the .

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

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 available with the .

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                                                                  |
+---------------------------------------------------------------------+

extract_table_from_file_name

Syntax

Description

Examples

See also

extract_table_from_file_name

Syntax

Description

Examples

See also

extract_table_from_file_name

hashtagSyntax

hashtagDescription

hashtagExamples

hashtagSee also

extract_table_from_file_name

hashtagSyntax

hashtagDescription

hashtagExamples

hashtagSee also

Syntax

Description

Examples

See also

Syntax

Description

Examples

See also