Documentation Home
MySQL 9.4 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 41.2Mb
PDF (A4) - 41.3Mb
Man Pages (TGZ) - 262.8Kb
Man Pages (Zip) - 368.8Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb


MySQL 9.4 Reference Manual  / ...  / MySQL sys Schema  / sys Schema Object Reference  / sys Schema Stored Functions  /  The extract_table_from_file_name() Function

30.4.5.2 The extract_table_from_file_name() Function

Given a file path name, returns the path component that represents the table name.

This function is useful when extracting file I/O information from the Performance Schema that includes file path names. It provides a convenient way to display table names, which can be more easily understood than full path names, and can be used in joins against object table names.

Parameters

  • path VARCHAR(512): The full path to a data file from which to extract the table name.

Return Value

AVARCHAR(64) value.

Example
mysql> SELECT sys.extract_table_from_file_name('/usr/local/mysql/data/world/City.ibd');+--------------------------------------------------------------------------+| sys.extract_table_from_file_name('/usr/local/mysql/data/world/City.ibd') |+--------------------------------------------------------------------------+| City                                                                     |+--------------------------------------------------------------------------+