PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/binary-log-mysql-database.html
This pertains to statements such as INSERT, UPDATE, DELETE, REPLACE, DO, LOAD DATA, SELECT, and TRUNCATE TABLE. The CREATE TABLE part is logged using statement format and the SELECT part is logged according to the value of binlog_format. The ...
https://dev.mysql.com/doc/refman/5.7/en/blob.html
For TEXT and BLOB columns, there is no padding on insert and no bytes are stripped on select. A BLOB is a binary large object that can hold a variable amount of data. These differ only in the maximum length of the values they can hold. These ...
https://dev.mysql.com/doc/refman/5.7/en/charset-metadata.html
Otherwise, neither the SHOW statements nor SELECT statements for tables in INFORMATION_SCHEMA would work properly because different rows in the same column of the results of these operations would be in different character sets. When you use SELECT ... Metadata is “the data about the data.” Anything that describes the database—as opposed to being the contents of the database—is ...
https://dev.mysql.com/doc/refman/5.7/en/checking-gpg-signature-windows.html
Figure 2.2 Kleopatra: Lookup Certificates on Server Wizard: Finding a Certificate Select the "MySQL Release Engineering" certificate. Select our certificate, then from the main menu select Certificates, Change Owner Trust.... Select I believe checks ... The Section 2.1.4.2, “Signature Checking Using GnuPG” section describes how to verify MySQL downloads using ...
https://dev.mysql.com/doc/refman/5.7/en/command-line-options.html
For example: $> mysql -u root -p -e "SELECT VERSION();SELECT NOW()" Enter password: ****** +------------+ | VERSION() | +------------+ | 5.7.29 | +------------+ +---------------------+ | NOW() | +---------------------+ | 2019-09-03 10:36:28 | ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-ndb-comment-options.html
The text of the comment is also available from querying the MySQL Information Schema TABLES table, as in this example: mysql> SELECT TABLE_NAME, TABLE_SCHEMA, TABLE_COMMENT > FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME="t1"\G ... NDB_COLUMN ...
https://dev.mysql.com/doc/refman/5.7/en/creating-ssl-files-using-openssl.html
During installation, leave the default C:\OpenSSL-Win32 as the install path, and also leave the default option 'Copy OpenSSL DLL files to the Windows system directory' selected. When the installation has finished, add C:\OpenSSL-Win32\bin to the ...
https://dev.mysql.com/doc/refman/5.7/en/declare-handler.html
If the program was called by another stored program, the calling program handles the condition using the handler selection rules applied to its own handlers. HANDLER statement had not been present, MySQL would have taken the default action (EXIT) ...
https://dev.mysql.com/doc/refman/5.7/en/distinct-optimization.html
Because DISTINCT may use GROUP BY, learn how MySQL works with columns in ORDER BY or HAVING clauses that are not part of the selected columns. In the following case, assuming that t1 is used before t2 (which you can check with EXPLAIN), MySQL stops ... DISTINCT combined with ORDER BY needs a temporary table in many ...
https://dev.mysql.com/doc/refman/5.7/en/do.html
In most respects, DO is shorthand for SELECT expr, ..., but has the advantage that it is slightly faster when you do not care about the result. It cannot be used in all cases where SELECT can be used. DO is useful primarily with functions that have ...