Search Results
https://dev.mysql.com/doc/refman/8.4/en/added-deprecated-removed.html
telemetry.query_text_enabled: Controls whether the SQL query text is included in the trace (Linux only). Options and Variables Introduced in MySQL 8.4 Options and Variables Deprecated in MySQL 8.4 Options and Variables Removed in MySQL 8.4 This ...
https://dev.mysql.com/doc/refman/8.4/en/adding-character-set.html
The syntax for the file is very simple: Comments are written as ordinary XML comments (<!-- text -->). This section discusses the procedure for adding a character set to MySQL. The proper procedure depends on whether the character set is simple or ...
https://dev.mysql.com/doc/refman/8.4/en/aggregate-functions.html
The result type is TEXT or BLOB unless group_concat_max_len is less than or equal to 512, in which case the result type is VARCHAR or VARBINARY. This section describes aggregate functions that operate on sets of values. They are often used with a ...
https://dev.mysql.com/doc/refman/8.4/en/archive-storage-engine.html
The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small footprint. To enable this storage engine if you build MySQL from source, invoke CMake with the -DWITH_ARCHIVE_STORAGE_ENGINE ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-security.html
By default, contents of audit log files produced by the audit log plugin are not encrypted and may contain sensitive information, such as the text of SQL statements. For security reasons, audit log files should be written to a directory accessible ...
https://dev.mysql.com/doc/refman/8.4/en/batch-mode.html
filename See Section 6.5.1.5, “Executing SQL Statements from a Text File”, for more information. In the previous sections, you used mysql interactively to enter statements and view the results. If you want the script to continue even if some of ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log.html
Passwords in statements written to the binary log are rewritten by the server not to occur literally in plain text. The binary log contains “events” that describe database changes such as table creation operations or changes to table data. It ...
https://dev.mysql.com/doc/refman/8.4/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/8.4/en/case-sensitivity.html
For nonbinary strings (CHAR, VARCHAR, TEXT), string searches use the collation of the comparison operands. One context in which you can expect to see binary is for compression functions, which return binary strings as a general rule: string: mysql> ...For binary strings (BINARY, VARBINARY, BLOB), comparisons use the numeric values of the bytes in the operands; this means that for alphabetic characters, comparisons are ...
https://dev.mysql.com/doc/refman/8.4/en/charset-conversion.html
If the column has a nonbinary data type (CHAR, VARCHAR, TEXT), its contents should be encoded in the column character set, not some other character set. To convert a binary or nonbinary string column to use a particular character set, use ALTER ...