PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/charset-literal.html
The examples use SET NAMES (which changes character_set_connection, as discussed in Section 10.4, “Connection Character Sets and Collations”), and display the resulting strings using the HEX() function so that the exact string contents can be ...
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). The rules for changing the value are as follows: Operator function is determined by position ...
https://dev.mysql.com/doc/refman/5.7/en/cast-functions.html
Table 12.15 Cast Functions and Operators Name Description BINARY Cast a string to a binary string CAST() Cast a value as a certain type CONVERT() Cast a value as a certain type Cast functions and operators enable conversion of values from one data ...A common use for BINARY is to force a character string comparison to be done byte by byte using numeric byte values rather than character by ...
https://dev.mysql.com/doc/refman/5.7/en/create-procedure.html
For example, if a function specifies an ENUM or SET value in the RETURNS clause, but the RETURN statement returns an integer, the value returned from the function is the string for the corresponding ENUM member of set of SET members. The CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/locking-service.html
MySQL distributions provide a locking interface that is accessible at two levels: At the SQL level, as a set of loadable functions that each map onto calls to the service routines. As a C language interface, callable as a plugin service from server ...For general information about plugin services, see Section 5.5.6, “MySQL Plugin ...
https://dev.mysql.com/doc/refman/5.7/en/mathematical-functions.html
HEX(N_or_S) This function can be used to obtain a hexadecimal representation of a decimal number or a string; the manner in which it does so varies according to the argument's type. See this function's description in Section 12.8, “String ...
https://dev.mysql.com/doc/refman/5.7/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 12.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/5.7/en/drop-function-loadable.html
DROP FUNCTION [IF EXISTS] function_name This statement drops the loadable function named function_name. (DROP FUNCTION is also used to drop stored functions; see Section 13.1.27, “DROP PROCEDURE and DROP FUNCTION Statements”.) DROP FUNCTION is ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-stored-procs.html
Where can I find documentation for MySQL stored procedures and stored functions? A.4.3. Is there a way to view all stored procedures and stored functions in a given database? A.4.7. Is it possible to group stored procedures or stored functions into ...Where can I find the ANSI SQL 2003 specification for stored procedures? ...
https://dev.mysql.com/doc/refman/5.7/en/information-functions.html
Memory structures already allocated are reused, and runtime optimizations such as local caching of results already evaluated for aggregate functions can alter the results. mysql> SELECT CHARSET('abc'); -> 'latin1' mysql> SELECT CHARSET(CONVERT('abc' ...It may be used to time how quickly MySQL processes the ...