Search Results
Displaying 191 to 200
of 206 total results
- « Previous
- 18
- 19
- 20
- 21
- Next »
https://dev.mysql.com/doc/refman/8.4/en/selecting-rows.html
Instead, you're usually more interested in answering a particular question, in which case you specify some constraints on the information you want. As shown in the preceding section, it is easy to retrieve an entire table. But typically you don't ...
https://dev.mysql.com/doc/refman/8.4/en/server-options.html
--check-table-functions=value Command-Line Format --check-table-functions=value Introduced 8.4.5 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.4/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.4/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.4/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.4/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.4/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.4/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.4/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 ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-5.html
If this happens in a table's constraints, default expressions, partitioning expressions, or virtual columns, the table could not be opened. (Bug #37570206) Audit Log Notes <COMMAND_CLASS> was not populated for <NAME>Execute</NAME>. (Bug #36686351) ...
Displaying 191 to 200
of 206 total results
- « Previous
- 18
- 19
- 20
- 21
- Next »