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/create-table-check-constraints.html
Note Constraint expression evaluation uses the SQL mode in effect at evaluation time. CREATE TABLE permits the core features of table and column CHECK constraints, for all storage engines. CREATE TABLE permits the following CHECK constraint syntax, ...
https://dev.mysql.com/doc/refman/9.7/en/create-table-foreign-keys.html
NDB supports deferred checks, and NO ACTION specifies a deferred check; when this is used, constraint checks are not performed until commit time. MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign ...
https://dev.mysql.com/doc/refman/9.7/en/create-table-generated-columns.html
If a generated column uses the TIMESTAMP data type, the setting for explicit_defaults_for_timestamp is ignored. In such cases, if this variable is disabled then NULL is not converted to CURRENT_TIMESTAMP. Note Expression evaluation uses the SQL mode ...Values of a generated column are computed from an expression included in the column ...
https://dev.mysql.com/doc/refman/9.7/en/create-table-gipks.html
Since sql_generate_invisible_primary_key was OFF at the time that auto_0 was created, no such additions were performed on that table. MySQL 9.7 supports generated invisible primary keys for any InnoDB table that is created without an explicit ...
https://dev.mysql.com/doc/refman/9.7/en/create-table-secondary-indexes.html
A secondary index defined on a virtual column is sometimes referred to as a “virtual index”. If a secondary index is not defined on a virtual column, there are additional costs for reads, as virtual column values must be computed each time the ...A secondary index may be created on one or more virtual columns or on a combination of virtual columns and regular columns or stored generated ...
https://dev.mysql.com/doc/refman/9.7/en/create-table.html
The column_list used in the COLUMNS clause may contain only names of columns; each column in the list must be one of the following MySQL data types: the integer types; the string types; and time or date column types. | {FULLTEXT | SPATIAL} [INDEX | ...
https://dev.mysql.com/doc/refman/9.7/en/creating-ssl-files-using-openssl.html
This section describes how to use the openssl command to set up SSL certificate and key files for use by MySQL servers and clients. The first example shows a simplified procedure such as you might use from the command line. The first two examples ...
https://dev.mysql.com/doc/refman/9.7/en/creating-ssl-rsa-files-using-mysql.html
They can be enabled at startup and inspected but not set at runtime. SSL files created by the server are valid for ten years from the time of generation. MySQL provides these ways to create the SSL certificate and key files and RSA key-pair files ...
https://dev.mysql.com/doc/refman/9.7/en/custom-benchmarks.html
Most of the time, these problems would be much easier to fix if the systems were not already in production. Benchmark your application and database to find out where the bottlenecks are. After fixing one bottleneck (or by replacing it with a ...
https://dev.mysql.com/doc/refman/9.7/en/data-dictionary-object-cache.html
The stored_program_cache option sets a soft upper limit for the number of cached stored procedures or functions per connection, and the limit is checked each time a connection executes a stored procedure or function. The dictionary object cache is ...