PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations.html
The following constructs are not permitted in partitioning expressions: Stored procedures, stored functions, loadable functions, or plugins. For a list of SQL functions which are permitted in partitioning expressions, see Section 22.6.3, ... This ...
https://dev.mysql.com/doc/refman/5.7/en/password-hashing.html
This includes removal of the mysql_old_password authentication plugin and the OLD_PASSWORD() function. The client can do this by using the PASSWORD() function to generate a password hash, or by using a password-generating statement (CREATE USER, ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines-syntax.html
A stored routine is either a procedure or a function. Stored routines are created with the CREATE PROCEDURE and CREATE FUNCTION statements (see Section 13.1.16, “CREATE PROCEDURE and CREATE FUNCTION Statements”). A function can be called from ...A procedure is invoked using a CALL statement (see Section 13.2.1, “CALL Statement”), and can only pass back values using output ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-file-formats.html
Valid XML characters are: #x9 | #xA | #xD | [#x20-#xD7FF] | [#xE000-#xFFFD] | [#x10000-#x10FFFF] The following elements are mandatory in every <AUDIT_RECORD> element: <NAME> A string representing the type of instruction that generated the audit ...
https://dev.mysql.com/doc/refman/5.7/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 12.7, “Date and Time ...
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/version-tokens-reference.html
The following discussion serves as a reference to these Version Tokens elements: Version Tokens Functions Version Tokens System Variables Version Tokens Functions The Version Tokens plugin library includes several functions. One set of functions ...
https://dev.mysql.com/doc/refman/5.7/en/extensions-to-ansi.html
For example, all string functions support both standard SQL syntax and ODBC syntax. RENAME and let the server rename the files.) General language syntax By default, strings can be enclosed by " as well as '. If the ANSI_QUOTES SQL mode is enabled, ... MySQL Server supports some extensions that are likely not to be found in other SQL ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-parameters-table.html
The PARAMETERS table provides information about parameters for stored routines (stored procedures and stored functions), and about return values for stored functions. The PARAMETERS table does not include built-in (native) functions or loadable ...