PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/partitioning-overview.html
All columns used in the table's partitioning expression must be part of every unique key that the table may have, including any primary key. Possible workarounds in this situation include adding the name column to the table's primary key, adding the ... This section provides a conceptual overview of partitioning in MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/structured-system-variables.html
Structured variable instances and components follow these naming rules: For a given type of structured variable, each instance must have a name that is unique within variables of that type. However, instance names need not be unique across ... A ...
https://dev.mysql.com/doc/refman/9.7/en/ansi-diff-foreign-keys.html
In an SQL statement that inserts, deletes, or updates many rows, foreign key constraints (like unique constraints) are checked row-by-row. (It is possible to implement other semantics using triggers.) A FOREIGN KEY constraint that references a ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-logging-configuration.html
Consider the following set of archived encrypted log file names: audit.20190410T205827.log.20190403T185337-1.enc audit.20190410T210243.log.20190403T185337-1.enc audit.20190415T145309.log.20190414T223342-1.enc ... This section describes how to ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-logging-configuration.html
Consider the following set of archived encrypted log file names: audit.20190410T205827.log.20190403T185337-1.enc audit.20190410T210243.log.20190403T185337-1.enc audit.20190415T145309.log.20190414T223342-1.enc ... Important The audit_log plugin is ...
https://dev.mysql.com/doc/refman/9.7/en/create-spatial-reference-system.html
SRID values must be unique, so if neither OR REPLACE nor IF NOT EXISTS is specified, an error occurs if an SRS definition with the given srid value already exists. The combination of the ORGANIZATION org_name and org_id attribute values must be ...
https://dev.mysql.com/doc/refman/9.7/en/create-table-foreign-keys.html
The CONSTRAINT symbol value, if defined, must be unique in the database. Previously, InnoDB allowed a foreign key to reference any index column or group of columns, even a non-unique index or partial index, an extension of standard SQL. NDB always ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...
https://dev.mysql.com/doc/refman/9.7/en/firewall-plugin.html
The profile-based protection afforded by the firewall enables implementation of strategies such as those listed here: If an application has unique protection requirements, have it use an account not used for any other purpose, and set up a group ...
https://dev.mysql.com/doc/refman/9.7/en/general-tablespaces.html
If the ADD DATAFILE clause is not specified when creating a tablespace, a tablespace data file with a unique file name is created implicitly. The unique file name is a 128 bit UUID formatted into five groups of hexadecimal numbers separated by ... A ...
https://dev.mysql.com/doc/refman/9.7/en/group-by-handling.html
The query is invalid if name is not a primary key of t or a unique NOT NULL column. SQL-92 and earlier does not permit queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are not named in the ...