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/stored-routines.html
Banks, for example, use stored procedures and functions for all common operations. Stored routines also enable you to have libraries of functions in the database server. Additional Resources You may find the Stored Procedures User Forum of use when ...A stored routine is a set of SQL statements that can be stored in the ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-optimization-with-exists.html
To solve the dilemma of whether or not to push down conditions into the subquery, the conditions are wrapped within “trigger” functions. AND trigcond(oe_N=ie_N) ) Each trigcond(X) is a special function that evaluates to the following values: X ... Certain optimizations are applicable to comparisons that use the IN (or =ANY) operator to test subquery ...
https://dev.mysql.com/doc/refman/5.7/en/binary-varbinary.html
The BINARY and VARBINARY types are similar to CHAR and VARCHAR, except that they store binary strings rather than nonbinary strings. For the latter types, the BINARY attribute does not cause the column to be treated as a binary string column. This ...
https://dev.mysql.com/doc/refman/5.7/en/connection-options.html
--host=host_name, -h host_name Command-Line Format --host=host_name Type String Default Value localhost The host on which the MySQL server is running. --password[=pass_val], -p[pass_val] Command-Line Format --password[=password] Type String Default ... This section describes options supported by most MySQL client programs that control how client programs establish connections to the server and whether connections are ...
https://dev.mysql.com/doc/refman/5.7/en/account-names.html
Quotes must be used if a user_name string contains special characters (such as space or -), or a host_name string contains special characters or wildcard characters (such as . Quote user names and host names as identifiers or as strings, using ...
https://dev.mysql.com/doc/refman/5.7/en/create-index.html
However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for nonbinary string types (CHAR, VARCHAR, TEXT) and number of bytes for binary string types (BINARY, ... CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ...
https://dev.mysql.com/doc/refman/5.7/en/hexadecimal-literals.html
To convert a string or a number to a string in hexadecimal format, use the HEX() function: mysql> SELECT HEX('cat'); +------------+ | HEX('cat') | +------------+ | 636174 | +------------+ mysql> SELECT X'636174'; +-----------+ | X'636174' | ...For ... Hexadecimal literal values are written using X'val' or 0xval notation, where val contains hexadecimal digits (0..9, ...
https://dev.mysql.com/doc/refman/5.7/en/set.html
A SET is a string object that can have zero or more values, each of which must be chosen from a list of permitted values specified when the table is created. See String Type Storage Requirements for storage requirements for the SET type. See ...SET ...
https://dev.mysql.com/doc/refman/5.7/en/charset-metadata.html
Thus column names, database names, user names, version names, and most of the string results from SHOW are metadata. The metadata requirements mean that the return values of the USER(), CURRENT_USER(), SESSION_USER(), SYSTEM_USER(), DATABASE(), and ... Metadata is “the data about the data.” Anything that describes the database—as opposed to being the contents of the database—is ...
https://dev.mysql.com/doc/refman/5.7/en/source-configuration-options.html
-DWITH_ZLIB=zlib_type Some features require that the server be built with compression library support, such as the COMPRESS() and UNCOMPRESS() functions, and compression of the client/server protocol. The CMake program provides a great deal of ...