MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 501 to 510 of 511 total results

https://dev.mysql.com/doc/refman/8.0/en/time-zone-support.html

Beginning with MySQL 8.0.19, time zone offsets are also supported for inserted datetime values; see Section 13.2.2, “The DATE, DATETIME, and TIMESTAMP Types”, for more information. For information about time zone settings in replication setups, ... This section describes the time zone settings maintained by MySQL, how to load the system tables required for named time support, how to stay current with time zone changes, and how to enable leap-second ...

13.2.9 2-Digit Years in Dates

https://dev.mysql.com/doc/refman/8.0/en/two-digit-years.html

The fix in this case is to convert the YEAR to 4-digit year format. Date values with 2-digit years are ambiguous because the century is unknown. Such values must be interpreted into 4-digit form because MySQL stores years internally using 4 digits.

6.10 Unix Signal Handling in MySQL

https://dev.mysql.com/doc/refman/8.0/en/unix-signal-response.html

For information about log rotation, see Section 7.4.6, “Server Log Maintenance”. On Unix and Unix-like systems, a process can be the recipient of signals sent to it by the root system account or the system account that owns the process. Some ...

10.2.5.2 Optimizing UPDATE Statements

https://dev.mysql.com/doc/refman/8.0/en/update-optimization.html

For a MyISAM table that uses dynamic row format, updating a row to a longer total length may split the row. An update statement is optimized like a SELECT query with the additional overhead of a write. The speed of the write depends on the amount ...

15.2.17 UPDATE Statement

https://dev.mysql.com/doc/refman/8.0/en/update.html

For more information, see The Effect of IGNORE on Statement Execution. (This is because the order in which the rows are updated determines which rows are ignored.) Such statements produce a warning in the error log when using statement-based mode ...

3.7 Upgrading MySQL Binary or Package-based Installations on Unix/Linux

https://dev.mysql.com/doc/refman/8.0/en/upgrade-binary-package.html

To perform an in-place upgrade: Review the information in Section 3.1, “Before You Begin”. It also brings the Performance Schema, INFORMATION_SCHEMA, and sys databases up to date for MySQL 8.0, and examines all user databases for ... This ...

8.3.1 Configuring MySQL to Use Encrypted Connections

https://dev.mysql.com/doc/refman/8.0/en/using-encrypted-connections.html

For additional information about the REQUIRE clause, see Section 15.7.1.3, “CREATE USER Statement”. For example, to require an encrypted connection and the use of a valid X.509 certificate, use REQUIRE X509: CREATE USER 'jeffrey'@'localhost' ...

9.4 Using mysqldump for Backups

https://dev.mysql.com/doc/refman/8.0/en/using-mysqldump.html

Tip Consider using the MySQL Shell dump utilities, which provide parallel dumping with multiple threads, file compression, and progress information display, as well as cloud features such as Oracle Cloud Infrastructure Object Storage streaming, and ...Dumps can be easily imported into a MySQL Server instance or a MySQL HeatWave DB System using the MySQL Shell load dump ...

15.2.20 WITH (Common Table Expressions)

https://dev.mysql.com/doc/refman/8.0/en/with.html

Common Table Expressions Recursive Common Table Expressions Limiting Common Table Expression Recursion Recursive Common Table Expression Examples Common Table Expressions Compared to Similar Constructs For information about CTE optimization, see ...

15.3.8.1 XA Transaction SQL Statements

https://dev.mysql.com/doc/refman/8.0/en/xa-statements.html

An xid value has from one to three parts: xid: gtrid [, bqual [, formatID ]] gtrid is a global transaction identifier, bqual is a branch qualifier, and formatID is a number that identifies the format used by the gtrid and bqual values. It is not ...

Displaying 501 to 510 of 511 total results