MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 211 to 220 of 225 total results

https://dev.mysql.com/doc/refman/9.7/en/show-triggers.html

SHOW TRIGGERS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TRIGGERS lists the triggers currently defined for tables in a database (the default database unless a FROM clause is given). This statement returns results only for databases ...

27.3.3 JavaScript Stored Program Language Support

https://dev.mysql.com/doc/refman/9.7/en/srjs-language-support.html

JavaScript language support in MySQL conforms to the ECMAScript 2024 Specification, and uses strict mode by default. This implementation includes all of the standard ECMAScript library objects such as Object, Function, Math, Date, String, and so ...

27.3.8 Using JavaScript Libraries

https://dev.mysql.com/doc/refman/9.7/en/srjs-libraries.html

This section provides information about and examples of use of JavaScript libraries in JavaScript stored programs as supported by the Multilingual Engine (MLE) in MySQL Enterprise Edition. First we create a database jslib, and make it the current ...

27.3.6.1 Session Object

https://dev.mysql.com/doc/refman/9.7/en/srjsapi-session.html

The Session object is always available as the session property of the global object. Session has the methods listed here: createSchema(String name): Creates a database having the specified name, and returns the corresponding Schema object. Returns ...

27.10 Restrictions on Stored Programs

https://dev.mysql.com/doc/refman/9.7/en/stored-program-restrictions.html

Some of the restrictions noted here apply to all stored routines; that is, both to stored procedures and stored functions. There are also some restrictions specific to stored functions but not to stored procedures. The restrictions for stored ...

27.9 Stored Program Binary Logging

https://dev.mysql.com/doc/refman/9.7/en/stored-programs-logging.html

The binary log contains information about SQL statements that modify database contents. This information is stored in the form of “events” that describe the modifications. (Binary log events differ from scheduled event stored objects.) The ...

10.4.6 Limits on Table Size

https://dev.mysql.com/doc/refman/9.7/en/table-size-limit.html

The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. For up-to-date information operating system file size limits, refer to the documentation ...

13.2.3 The TIME Type

https://dev.mysql.com/doc/refman/9.7/en/time.html

MySQL retrieves and displays TIME values in 'hh:mm:ss' format (or 'hhh:mm:ss' format for large hours values). The hours part may be so large because the TIME type can be used not only to represent a time of day (which must be less than 24 hours), ...

10.3.14 Indexed Lookups from TIMESTAMP Columns

https://dev.mysql.com/doc/refman/9.7/en/timestamp-lookups.html

Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted into and retrieved from TIMESTAMP columns are converted between the session time zone and UTC. (This is the same type of conversion performed by the CONVERT_TZ() ...

15.2.17 UPDATE Statement

https://dev.mysql.com/doc/refman/9.7/en/update.html

UPDATE is a DML statement that modifies rows in a table. An UPDATE statement can start with a WITH clause to define common table expressions accessible within the UPDATE. Single-table syntax: UPDATE [LOW_PRIORITY] [IGNORE] table_reference SET ...

Displaying 211 to 220 of 225 total results