15.7.7.25 SHOW LIBRARY STATUS Statement

SHOW LIBRARY STATUS
    [LIKE 'pattern' | WHERE expr]

This statement provides information about one or more JavaScript libraries. Like SHOW FUNCTION STATUS and SHOW PROCEDURE STATUS, it supports LIKE and WHERE clauses for filtering the output. See Section 15.7.7.31, “SHOW PROCEDURE STATUS Statement”, for information about how these clauses work.

SHOW LIBRARY STATUS contains the following columns:

Db
The name of the database containing the library.
Name
The name of the library.
Type
The library's type. This is always LIBRARY.
Creator
The account which created the library.
Modified
Timestamp showing when the library was last modified.
Created
Timestamp showing when the library was created.
Comment
Comment text, if any.

Example:

mysql> SHOW LIBRARY STATUS LIKE 'my_lib'\G
*************************** 1. row ***************************
                  Db: test
                Name: my_lib
                Type: LIBRARY
             Creator: jon@localhost
            Modified: 2025-03-21 08:42:17
             Created: 2025-01-13 17:24:08
             Comment: This is my_lib. There are many others like it, but 
                      this one is mine.
1 row in set (0.00 sec)

See Section 27.3.8, “Using JavaScript Libraries”, for more information.

The SHOW LIBRARY STATUS statement was added in MySQL 9.3.0.