PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/backup-types.html
INTO OUTFILE can be initiated from a local or remote client host, but the output file is created on the server host. This section describes the characteristics of different types of backups. Physical (Raw) Versus Logical Backups Physical backups ...
https://dev.mysql.com/doc/refman/5.7/en/binary-varbinary.html
For those cases where trailing pad bytes are stripped or comparisons ignore them, if a column has an index that requires unique values, inserting values into the column that differ only in number of trailing pad bytes results in a duplicate-key ...
https://dev.mysql.com/doc/refman/5.7/en/bnl-bka-optimization.html
If B2 is a regular join buffer, each row r put into B2 is composed of the columns of a row r1 from B1 and the interesting columns of a matching row r2 from table t3. When these operations are executed with a join buffer, each row put into the buffer ... In MySQL, a Batched Key Access (BKA) Join algorithm is available that uses both index access to the joined table and a join ...
https://dev.mysql.com/doc/refman/5.7/en/charset-configuration.html
The MySQL server has a compiled-in default character set and collation. To change these defaults, use the --character-set-server and --collation-server options when you start the server. The collation must be a legal collation for the default ...
https://dev.mysql.com/doc/refman/5.7/en/charset-repertoire.html
The repertoire of a character set is the collection of characters in the set. String expressions have a repertoire attribute, which can have two values: ASCII: The expression can contain only ASCII characters; that is, characters in the Unicode ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-utf32.html
For example, this is illegal: INSERT INTO t (utf32_column) VALUES (0x110000); /* illegal */ . The utf32 character set is fixed length (like ucs2 and unlike utf16). utf32 uses 32 bits for every character, unlike ucs2 (which uses 16 bits for every ...
https://dev.mysql.com/doc/refman/5.7/en/checking-gpg-signature-windows.html
Type "Mysql Release Engineering" into the search box and press Search. Either drag and drop the signature (.asc) file into Kleopatra, or load the dialog from File, Decrypt/Verify Files..., and then choose either the .msi or .asc file. The Section ...
https://dev.mysql.com/doc/refman/5.7/en/checking-gpg-signature.html
Another method of verifying the integrity and authenticity of a package is to use cryptographic signatures. This is more reliable than using MD5 checksums, but requires more work. GnuPG is an Open Source alternative to the well-known Pretty Good ...
https://dev.mysql.com/doc/refman/5.7/en/connection-access.html
It resolves this issue as follows: Whenever the server reads the user table into memory, it sorts the rows. +-----------+----------+- When the server reads the table into memory, it sorts the rows using the rules just described. When you attempt to ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-foreign-keys.html
MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. A foreign key relationship involves a parent table that holds the initial column ...