Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-utf32.html
utf32 takes twice as much space as ucs2 and more space than utf16, but utf32 has the same advantage as ucs2 that it is predictable for storage: The required number of bytes for utf32 equals the number of characters times 4. The utf32 character set ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-utf8.html
utf8 has been used by MySQL in the past as an alias for the utf8mb3 character set, but this usage is now deprecated; in MySQL 8.4, SHOW statements and columns of INFORMATION_SCHEMA tables display utf8mb3 instead. For more information, see Section ...
https://dev.mysql.com/doc/refman/8.4/en/charset.html
The default MySQL server character set and collation are utf8mb4 and utf8mb4_0900_ai_ci, but you can specify character sets at the server, database, table, column, and string literal levels. MySQL includes character set support that enables you to ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-options-variables.html
The requested data transfer rate specified by clone_max_data_bandwidth may differ from the actual data transfer rate reported by the DATA_SPEED column in the performance_schema.clone_progress table. This section describes the system variables that ...
https://dev.mysql.com/doc/refman/8.4/en/command-line-options.html
Program options specified on the command line follow these rules: Options are given after the command name. An option argument begins with one dash or two dashes, depending on whether it is a short form or long form of the option name. For example, ...
https://dev.mysql.com/doc/refman/8.4/en/comments.html
For example, MySQL Server recognizes the STRAIGHT_JOIN keyword in the following statement, but other servers should not: SELECT /*! STRAIGHT_JOIN */ col1 FROM table1,table2 WHERE ... MySQL Server supports three comment styles: From a # character to ...
https://dev.mysql.com/doc/refman/8.4/en/connecting-using-uri-or-key-value-pairs.html
This section describes use of URI-like connection strings or key-value pairs to specify how to establish connections to the MySQL server, for clients such as MySQL Shell. For information on establishing connections using command-line options, for ...For additional information if you are unable to connect, see Section 8.2.22, “Troubleshooting Problems Connecting to ...
https://dev.mysql.com/doc/refman/8.4/en/connection-interfaces.html
For comments on file descriptor limits, see Section 10.4.3.1, “How MySQL Opens and Closes Tables”. This section describes aspects of how the MySQL server manages client connections. Network Interfaces and Connection Manager Threads Client ...
https://dev.mysql.com/doc/refman/8.4/en/constraint-primary-key.html
Normally, errors occur for data-change statements (such as INSERT or UPDATE) that would violate primary-key, unique-key, or foreign-key constraints. If you are using a transactional storage engine such as InnoDB, MySQL automatically rolls back the ...
https://dev.mysql.com/doc/refman/8.4/en/cursors.html
Cursors have these properties: Asensitive: The server may or may not make a copy of its result table Read only: Not updatable Nonscrollable: Can be traversed only in one direction and cannot skip rows Cursor declarations must appear before handler ...