Search

Download this Manual
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


Displaying 131 to 138 of 138 total results
https://dev.mysql.com/doc/refman/8.0/en/server-options.html
--check-table-functions=value Command-Line Format --check-table-functions=value Introduced 8.0.42 Type Enumeration Default Value ABORT Valid Values WARNABORT When performing an upgade of the server, we scan the data dictionary for functions used in ... When you start the mysqld server, you can specify program options using any of the methods described in Section 6.2.2, “Specifying Program ...
https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html
Strict mode does not affect whether foreign key constraints are checked. The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system variable. DBAs ...
https://dev.mysql.com/doc/refman/8.0/en/storage-engines.html
To maintain data integrity, InnoDB also supports FOREIGN KEY referential-integrity constraints. Storage engines are MySQL components that handle the SQL operations for different table types. InnoDB is the default and most general-purpose storage ...
https://dev.mysql.com/doc/refman/8.0/en/table-size-limit.html
The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. For up-to-date information operating system file size limits, refer to the documentation ...
https://dev.mysql.com/doc/refman/8.0/en/using-innodb-tables.html
With so many constraints, often there is not an obvious set of columns to use as a primary key, so you create a new column with a numeric ID to serve as all or part of the primary key. InnoDB tables are created using the CREATE TABLE statement; for ...
https://dev.mysql.com/doc/refman/8.0/en/validate-password-options-variables.html
The value cannot be set less than the value of this expression: validate_password.number_count + validate_password.special_char_count + (2 * validate_password.mixed_case_count) If validate_password adjusts the value of validate_password.length due ... This section describes the system and status variables that validate_password provides to enable its operation to be configured and ...
https://dev.mysql.com/doc/refman/8.0/en/version-tokens-usage.html
The Version Tokens token-manipulation functions place these constraints on token names and values: Token names cannot contain = or ; characters and have a maximum length of 64 characters. Before using Version Tokens, install it according to the ...
https://dev.mysql.com/doc/refman/8.0/en/window-function-restrictions.html
The SQL standard imposes a constraint on window functions that they cannot be used in UPDATE or DELETE statements to update rows. Using such functions in a subquery of these statements (to select rows) is permitted. MySQL does not support these ...