SHOW-SMALL-FILES

Name

SHOW FILE

Description

This statement is used to display files created by the CREATE FILE command within a database.

  1. SHOW FILE [FROM database];

Return result description:

  • FileId: file ID, globally unique
  • DbName: the name of the database to which it belongs
  • Catalog: Custom Category
  • FileName: file name
  • FileSize: file size in bytes
  • MD5: MD5 of the file

Example

  1. View the uploaded files in the database my_database

    1. SHOW FILE FROM my_database;

Keywords

  1. SHOW, SMALL, FILES

Best Practice