Search Results
https://dev.mysql.com/doc/refman/8.4/en/aggregate-functions.html
MySQL bit functions and operators permit binary string type arguments (BINARY, VARBINARY, and the BLOB types) and return a value of like type, which enables them to take arguments and produce return values larger than 64 bits. The result type ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-functions-general-purpose.html
MySQL Server also includes an SQL interface for keyring key management, implemented as a set of general-purpose functions that access the capabilities provided by the internal keyring service. The keyring functions are contained in a plugin library ... MySQL Server supports a keyring service that enables internal components and plugins to store sensitive information securely for later ...
https://dev.mysql.com/doc/refman/8.4/en/create-function-loadable.html
CREATE [AGGREGATE] FUNCTION [IF NOT EXISTS] function_name RETURNS {STRING|INTEGER|REAL|DECIMAL} SONAME shared_library_name This statement loads the loadable function named function_name. DECIMAL is a legal value after RETURNS, but currently DECIMAL ...(CREATE FUNCTION is also used to created stored functions; see Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”.) A loadable function is a way to extend MySQL with a new function that works like a native (built-in) MySQL function such as ABS() or ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-real-escape-string-quote.html
unsigned long mysql_real_escape_string_quote(MYSQL *mysql, char *to, const char *from, unsigned long length, char quote) Description This function creates a legal SQL string for use in an SQL statement. For comparison, see the quoting rules for ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-real-escape-string.html
unsigned long mysql_real_escape_string(MYSQL *mysql, char *to, const char *from, unsigned long length) Description This function creates a legal SQL string for use in an SQL statement. For comparison, see the quoting rules for literal strings and ...Note mysql_real_escape_string() fails and produces an CR_INSECURE_API_ERR error if the NO_BACKSLASH_ESCAPES SQL mode is ...The ...
https://dev.mysql.com/doc/refman/8.4/en/case-sensitivity.html
One context in which you can expect to see binary is for compression functions, which return binary strings as a general rule: string: mysql> SELECT COLLATION(COMPRESS('x')); +--------------------------+ | COLLATION(COMPRESS('x')) | ... For ...
https://dev.mysql.com/doc/refman/8.4/en/connecting-using-uri-or-key-value-pairs.html
This section describes use of URI-like connection strings or key-value pairs to specify how to establish connections to the MySQL server, for clients such as MySQL Shell. Note The term “URI-like” signifies connection-string syntax that is ...
https://dev.mysql.com/doc/refman/8.4/en/charset-literal.html
The examples use SET NAMES (which changes character_set_connection, as discussed in Section 12.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/c-api/8.4/en/mysql-hex-string.html
unsigned long mysql_hex_string(char *to, const char *from, unsigned long length) Description This function creates a legal SQL string for use in an SQL statement. The string in the from argument is encoded in hexadecimal format, with each character ...The result is placed in the to argument, followed by a terminating null ...
https://dev.mysql.com/doc/refman/8.4/en/cast-functions.html
Table 14.15 Cast Functions and Operators Name Description Deprecated BINARY Cast a string to a binary string Yes CAST() Cast a value as a certain type CONVERT() Cast a value as a certain type Cast functions and operators enable conversion of values ...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 ...