PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/string-functions-charset.html
For operations that convert to character data, the character set and collation of the strings that result from the operations are defined by the character_set_connection and collation_connection system variables that determine the default connection ...This section answers the question: What is the character set and collation of such a string? For simple functions that take string input and return a string result as output, the output's character set and collation are the same as those of the principal input ...
https://dev.mysql.com/doc/refman/8.0/en/version-tokens.html
An SQL statement sent by the application to a server not in the required state produces an error. MySQL includes Version Tokens, a feature that enables creation of and synchronization around server tokens that applications can use to prevent ...
https://dev.mysql.com/doc/refman/8.0/en/creating-database.html
Otherwise, you need to create it yourself: mysql> CREATE DATABASE menagerie; Under Unix, database names are case-sensitive (unlike SQL keywords), so you must always refer to your database as menagerie, not as Menagerie, MENAGERIE, or some other ...
https://dev.mysql.com/doc/refman/8.0/en/create-function-loadable.html
IF NOT EXISTS prevents an error from occurring if there already exists a loadable function with the same name. It does not prevent an error from occurring if there already exists a built-in function having the same name. shared_library_name is the ... CREATE [AGGREGATE] FUNCTION [IF NOT EXISTS] function_name RETURNS {STRING|INTEGER|REAL|DECIMAL} SONAME shared_library_name This statement loads the loadable function named ...(CREATE FUNCTION is also used to created stored functions; see Section 15.1.17, “CREATE PROCEDURE ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-optimization.html
The column must be in the index and must immediately follow the columns in the GROUP BY. Any other parts of the index than those from the GROUP BY referenced in the query must be constants (that is, they must be referenced in equalities with ... The ...In some cases, MySQL is able to do much better than that and avoid creation of temporary tables by using index ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-ipv6.html
To use IPv6 addresses, the operating system on the server host and the MySQL Server instance must both be configured to support IPv6. When specified with a port number, an IPv6 address must be specified in square brackets, for example: ... As of ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-key.html
Any columns used as the partitioning key must comprise part or all of the table's primary key, if the table has one. If you define an explicit partitioning scheme for an NDB table, the table must have an explicit primary key, and any columns used in ... Partitioning by key is similar to partitioning by hash, except that where hash partitioning employs a user-defined expression, the hashing function for key partitioning is supplied by the MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/drop-user.html
(That is, the statement fails if dropping an account would cause a stored object to become orphaned.) To perform the operation anyway, you must have the SET_USER_ID privilege; in this case, the statement succeeds with a warning rather than failing ...To use DROP USER, you must have the global CREATE USER privilege, or the DELETE privilege for the mysql system ...
https://dev.mysql.com/doc/refman/8.0/en/gis-general-property-functions.html
If any SRID argument is not within the range of a 32-bit unsigned integer, an ER_DATA_OUT_OF_RANGE error occurs. If any geometry argument is not a syntactically well-formed geometry, an ER_GIS_INVALID_DATA error occurs. If a latitude value is not in ... The functions listed in this section do not restrict their argument and accept a geometry value of any ...
https://dev.mysql.com/doc/refman/8.0/en/connecting-using-dns-srv.html
When DNS SRV record lookup is used, clients generally must apply these rules for connection requests (there may be client- or connector-specific exceptions): The request must specify the full DNS SRV record name, with the service and protocol names ... In the Domain Name System (DNS), a SRV record (service location record) is a type of resource record that enables a client to specify a name that indicates a service, protocol, and ...