Documentation Home
MySQL 9.3 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.8Mb
PDF (A4) - 40.9Mb
Man Pages (TGZ) - 261.1Kb
Man Pages (Zip) - 368.3Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb


MySQL 9.3 Reference Manual  / ...  / INFORMATION_SCHEMA Tables  / INFORMATION_SCHEMA General Tables  /  The INFORMATION_SCHEMA LIBRARIES Table

28.3.18 The INFORMATION_SCHEMA LIBRARIES Table

TheLIBRARIES table contains information about JavaScript libraries known to the MLE JavaScript component (seeSection 7.5.7, “Multilingual Engine Component (MLE)”).

TheLIBRARIES table has these columns:

  • LIBRARY_CATALOG

    Library catalog name. Currently, this is alwaysdef.

  • LIBRARY_SCHEMA

    Schema (database) to which the library belongs.

  • LIBRARY_NAME

    Name of the library.

  • LIBRARY_DEFINITION

    Text of the library definition.

  • LANGUAGE

    Language. Currently, this is alwaysJAVASCRIPT.

  • CREATED

    Library creation date and time.

  • LAST_ALTERED

    Most recent date and time that the library was altered.

  • SQL_MODE

    SQL mode in effect at time of creation (seeSection 7.1.11, “Server SQL Modes”). This is a set consisting of none or any one or more of the following:REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ONLY_FULL_GROUP_BY,NO_UNSIGNED_SUBTRACTION,NO_DIR_IN_CREATE,ANSI,NO_AUTO_VALUE_ON_ZERO,NO_BACKSLASH_ESCAPES,STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,HIGH_NOT_PRECEDENCE,NO_ENGINE_SUBSTITUTION,PAD_CHAR_TO_FULL_LENGTH,TIME_TRUNCATE_FRACTIONAL. The default isONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION.

  • LIBRARY_COMMENT

    Comment specified, if any, when the library was created (or last altered, usingALTER LIBRARY).

    This column was added in MySQL 9.3.0.

  • CREATOR

    User account which created the library.

Example:

mysql> CREATE LIBRARY IF NOT EXISTS jslib.lib1 LANGUAGE JAVASCRIPT    ->     AS $$    $>       export function f(n) {    $>         return n    $>       }    $>     $$;Query OK, 0 rows affected (0.02 sec)mysql> CREATE LIBRARY IF NOT EXISTS jslib.lib2 LANGUAGE JAVASCRIPT    ->     AS $$    $>       export function g(n) {    $>         return n * 2    $>       }    $>     $$;Query OK, 0 rows affected (0.00 sec)mysql> SELECT * FROM information_schema.LIBRARIES    -> WHERE LIBRARY_SCHEMA='jslib'\G*************************** 1. row ***************************   LIBRARY_CATALOG: def    LIBRARY_SCHEMA: jslib      LIBRARY_NAME: lib1LIBRARY_DEFINITION:       export function f(n) {        return n      }              LANGUAGE: JAVASCRIPT           CREATED: 2024-12-16 09:20:26      LAST_ALTERED: 2024-12-16 09:20:26          SQL_MODE: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION           CREATOR: me@localhost*************************** 2. row ***************************   LIBRARY_CATALOG: def    LIBRARY_SCHEMA: jslib      LIBRARY_NAME: lib2LIBRARY_DEFINITION:       export function g(n) {        return n * 2      }              LANGUAGE: JAVASCRIPT           CREATED: 2024-12-16 09:20:26      LAST_ALTERED: 2024-12-16 09:20:26          SQL_MODE: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION           CREATOR: me@localhost2 rows in set (0.00 sec)