Search Results
MySQL 9.7 Reference Manual :: A.11 MySQL 9.7 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
https://dev.mysql.com/doc/refman/9.7/en/faqs-cjk.html
Many Windows users find that a Microsoft character set, such as cp932 for Japanese Windows, is suitable. Why do I get Incorrect string value error messages? To see the problem, create a table with one Unicode (ucs2) column and one Chinese (gb2312) ... This set of Frequently Asked Questions derives from the experience of MySQL's Support and Development groups in handling many inquiries about CJK (Chinese-Japanese-Korean) ...
https://dev.mysql.com/doc/refman/9.7/en/json-utility-functions.html
The argument can also be a valid JSON document or a string which can be parsed as one—either as a literal value or as the value of a user variable—in which case the function returns 0. In the case where it is string, the function returns the ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-limitations-storage-engines.html
CREATE TABLE and ALTER TABLE statements that would cause a user-partitioned NDB table not to meet either or both of the following two requirements are not permitted, and fail with an error: The table must have an explicit primary key. If a ...This ... In MySQL 9.7, partitioning support is not actually provided by the MySQL Server, but rather by a table storage engine's own or native partitioning ...
https://dev.mysql.com/doc/refman/9.7/en/replication-gtids-concepts.html
A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (the source). The tag is a user-defined string used to identify a specific group of transactions; see the ...This identifier is unique not only to the server on which it originated, but is unique across all servers in a given replication ...
https://dev.mysql.com/doc/refman/9.7/en/replication-privilege-checks-account.html
It is recommended that you never give any ACL privileges to the PRIVILEGE_CHECKS_USER account, including CREATE USER, CREATE ROLE, DROP ROLE, and GRANT OPTION, and do not permit the account to update the mysql.user table. With these privileges, the ... The user account that is specified using the CHANGE REPLICATION SOURCE TO statement as the PRIVILEGE_CHECKS_USER account for a replication channel must have the REPLICATION_APPLIER privilege, otherwise the replication applier thread does not ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/mysqlbackup.backup.html
We specify some of the connection information for the database using the --user and --host options (and, with the --password option, tell mysqlbackup to prompt for a user password). The unique ID for this backup job is recorded in special tables ...
https://dev.mysql.com/doc/refman/9.7/en/memory-storage-engine.html
User-Created and Temporary Tables MEMORY table contents are stored in memory, which is a property that MEMORY tables share with internal temporary tables that the server creates on the fly while processing queries. The MEMORY storage engine ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-snippets.html
Users connected to this MySQL server are allowed to create, edit, and use these shared snippets. The My Snippets option stores custom snippets in a file under the MySQL Workbench user's configuration directory. Table 8.1 Default Local Snippet File ... The Snippets secondary tab includes built-in, local, and shared custom ...
https://dev.mysql.com/doc/internals/en/sql-directory.html
Programs for handling SQL commands. The "core" of MySQL. These are the .c and .cc files in the sql directory: derror.cc --- read language-dependent message file des_key_file.cc --- load DES keys from plaintext file discover.cc --- Functions for ...
https://dev.mysql.com/doc/ndbapi/en/mccj-clusterj-sessionfactory.html
0 means that the receive thread is always active, and that retains poll rights for its own exclusive use, effectively blocking all user threads from becoming receivers. In such cases care should be taken to ensure that the receive thread does not ...