Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-table-check-constraints.html
CREATE TABLE permits the following CHECK constraint syntax, for both table constraints and column constraints: [CONSTRAINT [symbol]] CHECK (expr) [[NOT] ENFORCED] The optional symbol specifies a name for the constraint. CREATE TABLE permits the ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-gipks.html
MySQL 8.4 supports generated invisible primary keys for any InnoDB table that is created without an explicit primary key. When the sql_generate_invisible_primary_key server system variable is set to ON, the MySQL server automatically adds a ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-ndb-comment-options.html
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 table. Table-level options for controlling read from any replica and partition balance can be ...
https://dev.mysql.com/doc/refman/8.4/en/create-tablespace.html
The precise syntax and semantics depend on the storage engine used. MySQL NDB Cluster also supports tablespaces using the NDB storage engine. Considerations for InnoDB Considerations for NDB Cluster Options Notes InnoDB Examples NDB Example ...
https://dev.mysql.com/doc/refman/8.4/en/creating-accounts.html
Both are superuser accounts with full global privileges to do anything. To manage MySQL accounts, use the SQL statements intended for that purpose: CREATE USER and DROP USER create and remove accounts. GRANT and REVOKE assign privileges to and ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-object-cache.html
Both caches store table definitions but serve different parts of the MySQL server. The dictionary object cache is a shared global cache that stores previously accessed data dictionary objects in memory to enable object reuse and minimize disk I/O.
https://dev.mysql.com/doc/refman/8.4/en/data-masking-component-functions.html
Note If the term to replace appears in both dictionaries, it is possible for the return value to be the same term. mask_canada_sin(str [, mask_char]) Masks a Canada Social Insurance Number (SIN) and returns the number with all meaningful digits ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-component-usage.html
Both functions support an input string that is encoded in any character set: mask_inner() masks the interior of its string argument, leaving the ends unmasked. Before using MySQL Enterprise Data Masking and De-Identification, install it according ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-components-vs-plugin.html
Enabling both components and the plugin is unsupported and results may not be as anticipated. Previously, MySQL enabled masking and de-identification capabilities using a server-side plugin, but transitioned to use the component infrastructure as ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-plugin-functions.html
If the term to replace appears in both dictionaries, it is possible for the return value to be the same term. The MySQL Enterprise Data Masking and De-Identification plugin library includes several functions, which may be grouped into these ...