Documentation Home
MySQL 9.6 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 41.8Mb
PDF (A4) - 41.9Mb
Man Pages (TGZ) - 272.4Kb
Man Pages (Zip) - 378.2Kb
Info (Gzip) - 4.2Mb
Info (Zip) - 4.2Mb


30.4.5.4 The format_path() Function

Given a path name, returns the modified path name after replacing subpaths that match the values of the following system variables, in order:

datadirtmpdirreplica_load_tmpdirinnodb_data_home_dirinnodb_log_group_home_dirinnodb_undo_directorybasedir

A value that matches the value of system variablesysvar is replaced with the string@@GLOBAL.sysvar.

Parameters

  • path VARCHAR(512): The path name to format.

Return Value

AVARCHAR(512) CHARACTER SET utf8mb3 value.

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