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/get-diagnostics.html
Valid target designators for storing item information can be stored procedure or function parameters, stored program local variables declared with DECLARE, or user-defined variables. Valid condition_number designators can be stored procedure or ...
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/dynamic-format.html
Dynamic-format tables have these characteristics: All string columns are dynamic except those with a length less than four. Each row is preceded by a bitmap that indicates which columns contain the empty string (for string columns) or zero (for ...
https://dev.mysql.com/doc/refman/5.7/en/federated-create-server.html
If you are creating a number of FEDERATED tables on the same server, or if you want to simplify the process of creating FEDERATED tables, you can use the CREATE SERVER statement to define the server connection parameters, just as you would with the ...If you specify only the connection name without a table name, the table name of the local table is used ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldumpslow.html
Normally, mysqldumpslow groups queries that are similar except for the particular values of number and string data values. -a Do not abstract all numbers to N and strings to 'S'. -g pattern Type String Consider only queries that match the ... The ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math-expressions.html
If a numeric expression contains any strings, they are converted to double-precision floating-point values and the expression is approximate. For inserts of strings into numeric columns, conversion from string to number is handled as follows if the ... With precision math, exact-value numbers are used as given whenever ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-gtids.html
gtid_executed System Variable gtid_executed Scope Global Dynamic No Type String Unit set of GTIDs When used with global scope, this variable contains a representation of the set of all transactions executed on the server and GTIDs that have been set ... The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-sets.html
A combined character is considered different from the same character written with a single unicode character in string comparisons, and the two characters are considered to have a different length (for example, as returned by the CHAR_LENGTH() ...