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/string-type-syntax.html
In some cases, MySQL may change a string column to a type different from that given in a CREATE TABLE or ALTER TABLE statement. Specifying the CHARACTER SET binary attribute for a character string data type causes the column to be created as the ...
https://dev.mysql.com/doc/refman/8.0/en/drop-function-loadable.html
(DROP FUNCTION is also used to drop stored functions; see Section 15.1.29, “DROP PROCEDURE and DROP FUNCTION Statements”.) DROP FUNCTION is the complement of CREATE FUNCTION. During the normal startup sequence, the server loads functions ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking.html
For such cases, InnoDB creates a hidden clustered index and uses this index for record locking. Client A creates a table containing two index records (90 and 102) and then starts a transaction that places an exclusive lock on index records with an ...Shared and Exclusive Locks Intention Locks Record Locks Gap Locks Next-Key Locks Insert Intention Locks AUTO-INC Locks Predicate Locks for Spatial Indexes Shared and Exclusive Locks InnoDB implements standard row-level locking where there are two types of locks, shared (S) locks and exclusive (X) ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-migration.html
To move databases in a binary format from Unix to Windows or from Windows to Unix, create all databases and tables using lowercase names. In addition, MySQL Enterprise Backup can create compressed backup files, and back up subsets of tables. The ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-backups.html
Create any databases on the replica cluster that are present on the source cluster and that are to be replicated. Important A CREATE DATABASE (or CREATE SCHEMA) statement corresponding to each database to be replicated must be executed on each SQL ... This section discusses making backups and restoring from them using NDB Cluster ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-issues.html
Note Every NDB table is implicitly partitioned by key when it is created. Restarting the cluster with the --initial option causes the sequence of GCI and epoch numbers to start over from 0. This section discusses known problems or issues when using ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-functions.html
For this reason, if you select from the replica's copy of mytable after the CREATE TABLE and INSERT statements just shown have been replicated, you might expect mycol to contain the value 2009-09-01 18:00:00. Certain functions do not replicate well ...
https://dev.mysql.com/doc/refman/8.0/en/replication-upgrade.html
Behavior Changes Between Releases Although this upgrade sequence is correct, it is possible to still encounter replication difficulties when replicating from a source at an earlier release that has not yet been upgraded, to a replica at a later ...
https://dev.mysql.com/doc/refman/8.0/en/security-guidelines.html
A passphrase containing multiple words is easy to create, remember, and reproduce, and is much more secure than a typical user-selected password consisting of a single modified word or a predictable sequence of characters. To create a secure ...
https://dev.mysql.com/doc/refman/8.0/en/cast-functions.html
ARRAY is not supported except when used to create a multi-valued index in one of these statements, in which case it is required. Note CONVERT(), unlike CAST(), does not support multi-valued index creation or the ARRAY keyword. Other Uses for Cast ...