Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-table-check-constraints.html
expr specifies the constraint condition as a boolean expression that must evaluate to TRUE or UNKNOWN (for NULL values) for each row of the table. CREATE TABLE permits the core features of table and column CHECK constraints, for all storage engines. 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 ...
https://dev.mysql.com/doc/refman/8.4/en/docker-mysql-more-topics.html
Environment variables which can be used to configure a MySQL instance are listed here: The boolean variables including MYSQL_RANDOM_ROOT_PASSWORD, MYSQL_ONETIME_PASSWORD, MYSQL_ALLOW_EMPTY_PASSWORD, and MYSQL_LOG_CONSOLE are made true by setting ...
https://dev.mysql.com/doc/refman/8.4/en/full-text-adding-collation.html
Warning User-defined collations are deprecated; you should expect support for them to be removed in a future version of MySQL. The server issues a warning for any use of COLLATE user_defined_collation in an SQL statement; a warning is also issued ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-search-ngram.html
For boolean mode search, the search term is converted to an ngram phrase search. The built-in MySQL full-text parser uses the white space between words as a delimiter to determine where words begin and end, which is a limitation when working with ...
https://dev.mysql.com/doc/refman/8.4/en/glossary.html
full-text search The MySQL feature for finding words, phrases, Boolean combinations of words, and so on within table data, in a faster, more convenient, and more flexible way than using the SQL LIKE operator or writing your own application-level ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-columns-table.html
HAS_DEFAULT A boolean value indicating whether a column that was added instantly using ALTER TABLE ... For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_COLUMNS table ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-hashicorp-plugin.html
| +--------------------------------------+ 1 row in set (0.03 sec) If the plugin is not able to connect to HashiCorp Vault during initialization or reconfiguration and there was no existing connection, the _commit_ system variables are set to 'Not ... Note The keyring_hashicorp plugin is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.4/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...
https://dev.mysql.com/doc/refman/8.4/en/literals.html
These include strings, numbers, hexadecimal and bit values, boolean values, and NULL. This section describes how to write literal values in MySQL. The section also covers various nuances that you may encounter when dealing with these basic types in ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-general-options.html
--wait, -w Command-Line Format --wait Type Boolean Default Value false Instead of terminating with an error if the table is locked, wait until the table is unlocked before continuing. The options described in this section can be used for any type ...