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/source-configuration-options.html
To overcome this, an explicit full path to the directory is set in the DEB and RPM versions of mysqld, since the target destination is known. This value can be set at server startup with the --character-set-server option. Use the SHOW COLLATION ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-plugin-usage.html
For more information about generation functions, see Generating Random Data with Specific Characteristics. mask_ssn() masks all but the last four digits of the number: mysql> SELECT mask_ssn(gen_rnd_ssn()); +-------------------------+ | ... Before ...
https://dev.mysql.com/doc/refman/8.0/en/entering-queries.html
In MySQL, you can write strings surrounded by either ' or " characters (for example, 'hello' or "goodbye"), and mysql lets you enter strings that span multiple lines. When you see a '> or "> prompt, it means that you have entered a line containing a ... Make sure that you are connected to the server, as discussed in the previous ...
https://dev.mysql.com/doc/refman/8.0/en/hexadecimal-literals.html
Hexadecimal literal values are written using X'val' or 0xval notation, where val contains hexadecimal digits (0..9, A..F). Lettercase of the digits and of any leading X does not matter. A leading 0x is case-sensitive and cannot be written as 0X.
https://dev.mysql.com/doc/refman/8.0/en/import-table.html
The IMPORT TABLE statement imports MyISAM tables based on information contained in .sdi (serialized dictionary information) metadata files. IMPORT TABLE requires the FILE privilege to read the .sdi and table content files, and the CREATE privilege ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-columns-table.html
PRTYPE The InnoDB “precise type”, a binary value with bits representing MySQL data type, character set code, and nullability. For character columns in multibyte character sets, this length value is the maximum length in bytes needed to represent ...For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-parameters-table.html
The return value is not a true parameter, so the row that describes it has these unique characteristics: The ORDINAL_POSITION value is 0. The PARAMETERS table provides information about parameters for stored routines (stored procedures and stored ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-routines-table.html
CHARACTER_MAXIMUM_LENGTH For stored function string return values, the maximum length in characters. CHARACTER_OCTET_LENGTH For stored function string return values, the maximum length in bytes. CHARACTER_SET_NAME For stored function character ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-limits.html
For example, you might hit this limit with a column prefix index of more than 191 characters on a TEXT or VARCHAR column, assuming a utf8mb4 character set and the maximum of 4 bytes for each character. This section describes limits for InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/json-creation-functions.html
mysql> SELECT JSON_OBJECT('id', 87, 'name', 'carrot'); +-----------------------------------------+ | JSON_OBJECT('id', 87, 'name', 'carrot') | +-----------------------------------------+ | {"id": 87, "name": "carrot"} | ... The functions listed in ...