Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-query-attributes.html
Connector/J supports Query Attributes when it has been enabled on the server by installing the query_attributes component (see Prerequisites for Using Query Attributes for details). Attributes are set for a query by using the setAttribute() method ...
https://dev.mysql.com/doc/refman/8.4/en/account-activity-auditing.html
In this case, if a client connects as user1 from the local host, USER() and CURRENT_USER() return different values: mysql> SELECT USER(), CURRENT_USER(); +-----------------+----------------+ | USER() | CURRENT_USER() | ... Applications can use the ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/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/8.4/en/charset-repertoire.html
Consider these statements: SET NAMES utf8mb4; SELECT 'abc'; SELECT _utf8mb4'def'; Although the character set is utf8mb4 in each of the preceding cases, the strings do not actually contain any characters outside the ASCII range, so their repertoire ... The repertoire of a character set is the collection of characters in the ...
https://dev.mysql.com/doc/refman/8.4/en/command-line-options.html
For example: $> mysql -u root -p -e "SELECT VERSION();SELECT NOW()" Enter password: ****** +------------+ | VERSION() | +------------+ | 8.0.19 | +------------+ +---------------------+ | NOW() | +---------------------+ | 2019-09-03 10:36:48 | ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/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 ...