Search Results
https://dev.mysql.com/doc/internals/en/sql-directory.html
Programs for handling SQL commands. The "core" of MySQL. These are the .c and .cc files in the sql directory: derror.cc --- read language-dependent message file des_key_file.cc --- load DES keys from plaintext file discover.cc --- Functions for ...
https://dev.mysql.com/doc/refman/8.4/en/arithmetic-functions.html
If any of the operands of a +, -, /, *, % is a real or string value, the precision of the result is the precision of the operand with the maximum precision. For example, to add date values, use DATE_ADD(); see Section 14.7, “Date and Time ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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 14.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/8.4/en/data-masking-component-usage.html
General-Purpose Masking Component Functions mask_inner() and mask_outer() are general-purpose functions that mask parts of arbitrary strings based on position within the string. Both functions support an input string that is encoded in any character ...To use MySQL Enterprise Data Masking and De-Identification in applications, invoke the functions that are appropriate for the operations you wish to ... Before using MySQL Enterprise Data Masking and ...
https://dev.mysql.com/doc/internals/en/error-flags.html
In the field::store function this changes the warning level from WARN to ERROR. Error functions thd->really_abort_on_warning() This function returns 1 if a warning should be converted to an error, like in strict mode when all tables are ... The ...
https://dev.mysql.com/doc/refman/8.4/en/sys-format-statement.html
Given a string (normally representing an SQL statement), reduces it to the length given by the statement_truncate_len configuration option, and returns the result. Otherwise, the middle part of the string is replaced by an ellipsis (...). This ...
https://dev.mysql.com/doc/refman/8.4/en/sys-format-bytes.html
See Section 14.21, “Performance Schema Functions” Given a byte count, converts it to human-readable format and returns a string consisting of a value and a units indicator. Applications that use it should be migrated to use the built-in ... Note ...
https://dev.mysql.com/doc/refman/8.4/en/sys-format-time.html
See Section 14.21, “Performance Schema Functions” Given a Performance Schema latency or wait time in picoseconds, converts it to human-readable format and returns a string consisting of a value and a units indicator. Applications that use it ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-usagenotes-functionality-catalog-schema.html
The expectation on how to interpret these schema and catalog notions differs between developers, which is why both the NO_CATALOG and NO_SCHEMA options exist: to cover all these expectations and allow one to disable interpreting ODBC function ...