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/binary-log-formats.html
It is important therefore that tables always use a primary key to ensure rows can be efficiently identified. The server uses several logging formats to record information in the binary log. The exact format employed depends on the version of MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/bug-reports.html
The options to programs such as mysqld and mysql, and to the configure script, are often key to resolving problems and are very relevant. Before posting a bug report about a problem, please try to verify that it is a bug and that it has not been ...
https://dev.mysql.com/doc/refman/5.7/en/change-replication-filter.html
Filters set using this statement differ from those set using the server options in two key respects: The statement does not require restarting the server to take effect, only that the replication SQL thread be stopped using STOP SLAVE SQL_THREAD ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-utf16.html
The utf16 character set is the ucs2 character set with an extension that enables encoding of supplementary characters: For a BMP character, utf16 and ucs2 have identical storage characteristics: same code values, same encoding, same length. For a ...
https://dev.mysql.com/doc/refman/5.7/en/checking-gpg-signature-windows.html
The Fingerprint and Key-ID must be "3A79BD29" for MySQL 5.7.37 and higher or "5072E1F5" for MySQL 5.7.36 and earlier, or choose Details... The Section 2.1.4.2, “Signature Checking Using GnuPG” section describes how to verify MySQL downloads ...
https://dev.mysql.com/doc/refman/5.7/en/comments.html
For example, MySQL Server recognizes the STRAIGHT_JOIN keyword in the following statement, but other servers do not: SELECT /*! STRAIGHT_JOIN */ col1 FROM table1,table2 WHERE ... MySQL Server supports three comment styles: From a # character to the ...
https://dev.mysql.com/doc/refman/5.7/en/commit.html
In read-only mode, it remains possible to change tables created with the TEMPORARY keyword using DML statements. The BEGIN statement differs from the use of the BEGIN keyword that starts a BEGIN ... The optional WORK keyword is supported for COMMIT ...SET autocommit disables or enables the default autocommit mode for the current ...
https://dev.mysql.com/doc/refman/5.7/en/corrupted-myisam-tables.html
Typical symptoms of a corrupt table are: You get the following error while selecting data from the table: Incorrect key file for table: '...'. Even though the MyISAM table format is very reliable (all changes to a table made by an SQL statement are ...
https://dev.mysql.com/doc/refman/5.7/en/creating-spatial-indexes.html
For InnoDB and MyISAM tables, MySQL can create spatial indexes using syntax similar to that for creating regular indexes, but using the SPATIAL keyword. For storage engines that support nonspatial indexing of spatial columns, the engine creates a ...
https://dev.mysql.com/doc/refman/5.7/en/creating-tables.html
You want a table that contains a record for each of your pets. This can be called the pet table, and it should contain, as a bare minimum, each animal's name. Because the name by itself is not very interesting, the table should contain other ...