PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 255.5Kb
Man Pages (Zip)
- 360.4Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/json.html
Along with the JSON data type, a set of SQL functions is available to enable operations on JSON values, such as creation, manipulation, and searching. A set of spatial functions for operating on GeoJSON values is also available. MySQL NDB Cluster ...
https://dev.mysql.com/doc/refman/5.7/en/arithmetic-functions.html
For example, to add date values, use DATE_ADD(); see Section 12.7, “Date and Time Functions”. For more information, see the description for the MOD() function in Section 12.6.2, “Mathematical Functions”. Table 12.9 Arithmetic Operators Name ...
https://dev.mysql.com/doc/refman/5.7/en/select-benchmarking.html
To measure the speed of a specific MySQL expression or function, invoke the BENCHMARK() function using the mysql client program. The built-in MySQL functions are typically highly optimized, but there may be some exceptions. BENCHMARK() is an ...The ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines-last-insert-id.html
Within the body of a stored routine (procedure or function) or a trigger, the value of LAST_INSERT_ID() changes the same way as for statements executed outside the body of these kinds of objects (see Section 12.15, “Information Functions”). For ...The effect of a stored routine or trigger upon the value of LAST_INSERT_ID() that is seen by following statements depends on the kind of routine: If a stored procedure executes statements that change the value of LAST_INSERT_ID(), the changed value is seen by statements that follow the procedure ...
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html
A client that authenticates using the InitSecurityContext() function should provide a string identifying the service to which it connects (targetName). default_week_format Command-Line Format --default-week-format=# System Variable ... The MySQL ...
https://dev.mysql.com/doc/refman/5.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. SQL prepared statements (PREPARE, ...The restrictions for stored procedures also apply to the DO clause of Event Scheduler event ...
https://dev.mysql.com/doc/refman/5.7/en/sys-extract-schema-from-file-name.html
This function assumes that the file name lies within the schema directory. This function is useful when extracting file I/O information from the Performance Schema that includes file path names. Given a file path name, returns the path component ...
https://dev.mysql.com/doc/refman/5.7/en/sys-format-statement.html
This function is useful for formatting possibly lengthy statements retrieved from Performance Schema tables to a known fixed maximum length. Configuration Options format_statement() operation can be modified using the following configuration options ... Given a string (normally representing an SQL statement), reduces it to the length given by the statement_truncate_len configuration option, and returns the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-is-consumer-enabled.html
(Prior to MySQL 5.7.28, the function returns NULL if the argument is not a valid consumer name.) This function accounts for the consumer hierarchy, so a consumer is not considered enabled unless all consumers on which depends are also enabled.
https://dev.mysql.com/doc/refman/5.7/en/sys-extract-table-from-file-name.html
This function is useful when extracting file I/O information from the Performance Schema that includes file path names. Given a file path name, returns the path component that represents the table name. It provides a convenient way to display table ...