PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/create-table-select.html
If errors occur while copying data to the table, the table is automatically dropped and not created. You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl [AS] SELECT * ...
https://dev.mysql.com/doc/refman/8.0/en/deallocate-prepare.html
{DEALLOCATE | DROP} PREPARE stmt_name To deallocate a prepared statement produced with PREPARE, use a DEALLOCATE PREPARE statement that refers to the prepared statement name. Attempting to execute a prepared statement after deallocating it results ...
https://dev.mysql.com/doc/refman/8.0/en/declare-condition.html
DECLARE condition_name CONDITION FOR condition_value condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value } The DECLARE ... CONDITION statement declares a named error condition, associating a name with a condition that needs ...
https://dev.mysql.com/doc/refman/8.0/en/default-privileges.html
To set up additional accounts, see Section 8.2.8, “Adding Accounts, Assigning Privileges, and Dropping Accounts”. The MySQL installation process involves initializing the data directory, including the grant tables in the mysql system schema ...
https://dev.mysql.com/doc/refman/8.0/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. As of MySQL 8.0.33, the server issues a warning for any use of COLLATE user_defined_collation in an SQL statement; a ...
https://dev.mysql.com/doc/refman/8.0/en/gone-away.html
You are using a Windows client and the server had dropped the connection (probably because wait_timeout expired) before the command was issued. This section also covers the related Lost connection to server during query error. The most common ...
https://dev.mysql.com/doc/refman/8.0/en/group-by-handling.html
SQL-92 and earlier does not permit queries for which the select list, HAVING condition, or ORDER BY list refer to nonaggregated columns that are not named in the GROUP BY clause. SQL:1999 and later permits such nonaggregates per optional feature ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-distributed-recovery-fault.html
Warning For a remote cloning operation, user-created tablespaces and data on the recipient (the joining member) are dropped before the remote cloning operation begins to transfer the data from the donor. Group Replication's distributed recovery ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-frequently-asked-questions.html
However, if the network drops packets, leading to re-transmissions and higher end-to-end latency, throughput and latency are both negatively affected. What is the maximum number of MySQL servers in a group? A group can consist of maximum 9 servers.
https://dev.mysql.com/doc/refman/8.0/en/index-page-merge-threshold.html
If the “page-full” percentage for an index page falls below the MERGE_THRESHOLD value when a row is deleted or when a row is shortened by an UPDATE operation, InnoDB attempts to merge the index page with a neighboring index page. The default ...