SHOW FILE

Description

This statement is used to show the file created by the CREATE FILE command in a database.

SHOW FILE [FROM database];

Description of return results:

• FileId: file ID, globally unique
• DbName: Name of database to which it belongs
• Catalog: Custom classification
• FileName: File name
• FileSize: File size, in bytes
• MD5: MD5 of files.

Example

1. View the uploaded files in the database my_database

   SHOW FILE FROM my_database;

Keywords

SHOW,FILE