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/create-procedure.html
For example, if a function specifies an ENUM or SET value in the RETURNS clause, but the RETURN statement returns an integer, the value returned from the function is the string for the corresponding ENUM member of set of SET members. By default, a ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html
The size and sign of fixed precision types such as INTEGER and DECIMAL must be the same. Typically, you leave this variable enabled during normal operation to enforce referential integrity. MySQL supports foreign keys, which permit ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-ndb-comment-options.html
(Prior to NDB 8.0.30, only MAX_BLOB_PART_SIZE is supported.) Syntax for this option is shown here: COMMENT 'NDB_COLUMN=speclist' speclist := spec[,spec] spec := BLOB_INLINE_SIZE=value | MAX_BLOB_PART_SIZE[={0|1}] BLOB_INLINE_SIZE specifies the ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-component-usage.html
gen_range() returns a random integer selected from a given range: mysql> SELECT gen_range(1, 10); +------------------+ | gen_range(1, 10) | +------------------+ | 6 | +------------------+ gen_rnd_uk_nin() returns a random UK National Insurance ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-components-vs-plugin.html
Prior to 8.0.33, MySQL enabled masking and de-identification capabilities using a server-side plugin, but transitioned to use the component infrastructure in MySQL 8.0.33. The following table briefly compares MySQL Enterprise Data Masking and ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-plugin-installation.html
This section describes how to install or uninstall MySQL Enterprise Data Masking and De-Identification, which is implemented as a plugin library file containing a plugin and several loadable functions. For general information about installing or ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-plugin-usage.html
Before using MySQL Enterprise Data Masking and De-Identification, install it according to the instructions provided at Section 8.5.3.1, “MySQL Enterprise Data Masking and De-Identification Plugin Installation”. To use MySQL Enterprise Data ...
https://dev.mysql.com/doc/refman/8.0/en/data-size.html
For example, use the smaller integer types if possible to get smaller tables. Design your tables to minimize their space on the disk. This can result in huge improvements by reducing the amount of data written to and read from disk. Smaller tables ...
https://dev.mysql.com/doc/refman/8.0/en/data-types.html
Data type descriptions use these conventions: For integer types, M indicates the maximum display width. MySQL supports SQL data types in several categories: numeric types, date and time types, string (character and byte) types, spatial types, and ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-literals.html
Standard SQL and ODBC Date and Time Literals String and Numeric Literals in Date and Time Context Date and time values can be represented in several formats, such as quoted strings or as numbers, depending on the exact type of the value and other ...