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/constraints.html
MySQL enables you to work both with transactional tables that permit rollback and with nontransactional tables that do not. Because of this, constraint handling is a bit different in MySQL than in other DBMSs. We must handle the case when you have ...
https://dev.mysql.com/doc/refman/8.0/en/create-procedure.html
This option is supported with both CREATE FUNCTION and CREATE PROCEDURE beginning with MySQL 8.0.29. By default, a stored routine is associated with the default database. To associate the routine explicitly with a given database, specify the name as ...
https://dev.mysql.com/doc/refman/8.0/en/create-resource-group.html
A range is given in the form M − N, where M is less than or equal to N and both numbers are in the CPU range. CREATE RESOURCE GROUP group_name TYPE = {SYSTEM|USER} [VCPU [=] vcpu_spec [, vcpu_spec] ...] [THREAD_PRIORITY [=] N] [ENABLE|DISABLE] ...
https://dev.mysql.com/doc/refman/8.0/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. Prior to MySQL 8.0.16, ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-gipks.html
Beginning with MySQL 8.0.30, MySQL 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 ...
https://dev.mysql.com/doc/refman/8.0/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.0/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.0/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.0/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.0/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 ...