SHOW-FILE

Name

SHOW FILE

Description

This statement is used to display a file created in a database

grammar:

  1. SHOW FILE [FROM database];

illustrate:

  1. FileId: file ID, globally unique
  2. DbName: the name of the database to which it belongs
  3. Catalog: Custom Category
  4. FileName: file name
  5. FileSize: file size, in bytes
  6. 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, FILE

Best Practice