The LIBRARIES
table contains
information about JavaScript libraries known to the MLE JavaScript
component (see Section 7.5.8, “Multilingual Engine Component (MLE)”).
The LIBRARIES
table has these
columns:
LIBRARY_CATALOG
Library catalog name. Currently, this is always
def
.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 always
JAVASCRIPT
.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 (see Section 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
.CREATOR
User account which created the library.
Example:
Press CTRL+C to copymysql> 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: lib1 LIBRARY_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: lib2 LIBRARY_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@localhost 2 rows in set (0.00 sec)
The LIBRARIES
table was added in
MySQL 9.2.0.