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/grant-tables.html
The value is non-NULL only for accounts that use MySQL built-in authentication methods (accounts that use an authentication plugin of mysql_native_password or sha256_password). The value is NULL for other accounts, such as those authenticated using ... The mysql system database includes several grant tables that contain information about user accounts and the privileges held by ...
https://dev.mysql.com/doc/refman/5.7/en/data-type-defaults.html
In the definition of an integer column, it is an alias for NOT NULL AUTO_INCREMENT UNIQUE. Implicit Default Handling If a data type specification includes no explicit DEFAULT value, MySQL determines the default value as follows: If the column can ...
https://dev.mysql.com/doc/refman/5.7/en/storage-requirements.html
InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage Requirements Spatial Type Storage Requirements JSON Storage Requirements The storage ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-ndb-comment-options.html
For more information about how NDB stores columns of blob types, see String Type Storage Requirements. NDB_TABLE Options For an NDB Cluster table, the table comment in a CREATE TABLE or ALTER TABLE statement can also be used to specify an NDB_TABLE ... NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB ...
https://dev.mysql.com/doc/refman/5.7/en/selecting-rows.html
String comparisons normally are case-insensitive, so you can specify the name as 'bowser', 'BOWSER', and so forth. As shown in the preceding section, it is easy to retrieve an entire table. But typically you don't want to see the entire table, ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-usage.html
General-Purpose Masking Functions mask_inner() and mask_outer() are general-purpose functions that mask parts of arbitrary strings based on position within the string: mask_inner() masks the interior of its string argument, leaving the ends unmasked. Converting the value to a binary string ensures that the function sees an argument of length ... Before using MySQL Enterprise Data Masking and De-Identification, install it according to the instructions provided at ...
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/memory-storage-engine.html
(This is an uncommon feature for implementations of hash indexes.) Columns that are indexed can contain NULL values. To replicate this effect to replicas, the first time that the source uses a given MEMORY table after startup, it logs an event that ... The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in ...
https://dev.mysql.com/doc/refman/5.7/en/case.html
The CASE statement cannot have an ELSE NULL clause, and it is terminated with END CASE instead of END. This syntax cannot be used to test for equality with NULL because NULL = NULL is false. CASE case_value WHEN when_value THEN statement_list [WHEN ...
https://dev.mysql.com/doc/refman/5.7/en/merge-storage-engine.html
The column of the underlying table and the MERGE table can be NULL. The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be used as one. “Identical” means that all tables have ...