Search Results
https://dev.mysql.com/doc/refman/9.7/en/charset-conversion.html
A special case occurs if you have old tables from before MySQL 4.1 where a nonbinary column contains values that actually are encoded in a character set different from the server's default character set. Suppose that the server's default character ... To convert a binary or nonbinary string column to use a particular character set, use ALTER ...
https://dev.mysql.com/doc/refman/9.7/en/clone-plugin-stop.html
On the recipient MySQL server instance, you can retrieve the processlist identifier (PID) for a cloning operation from the PID column of the clone_status table. These methods of obtaining the PID information can be used on the donor or recipient ...
https://dev.mysql.com/doc/refman/9.7/en/collation-diagnostics.html
The MySQL server generates diagnostics when it finds problems while parsing the Index.xml file: Unknown tags are written to the error log. For example, the following message results if a collation definition contains a <aaa> tag: [Warning] Buffered ...In other cases, when a collation description is generally correct but contains some unknown tags, the collation is initialized and is available for ...
https://dev.mysql.com/doc/refman/9.7/en/connection-management.html
This includes a description of the available connection interfaces, how the server uses connection handler threads, details about the administrative connection interface, and management of DNS lookups.
https://dev.mysql.com/doc/refman/9.7/en/constraint-foreign-key.html
SET DEFAULT is also supported by the MySQL Server but is currently rejected as invalid by InnoDB. MATCH FULL, MATCH PARTIAL, and MATCH SIMPLE are allowed, but their use should be avoided, as they cause the MySQL Server to ignore any ON DELETE or ON ... Foreign keys let you cross-reference related data across tables, and foreign key constraints help keep this spread-out data ...
https://dev.mysql.com/doc/refman/9.7/en/csv-storage-engine.html
The CSV storage engine is always compiled into the MySQL server. When you create a CSV table, the server creates a plain text data file having a name that begins with the table name and has a .CSV extension. The CSV storage engine stores data in ...
https://dev.mysql.com/doc/refman/9.7/en/database-use.html
Use the SHOW statement to find out what databases currently exist on the server: mysql> SHOW DATABASES; +----------+ | Database | +----------+ | mysql | | test | | tmp | +----------+ The mysql database describes user access privileges. The ... Once ...
https://dev.mysql.com/doc/refman/9.7/en/date-and-time-types.html
(See Section 7.1.11, “Server SQL Modes”.) You can get MySQL to accept certain dates, such as '2009-11-31', by enabling the ALLOW_INVALID_DATES SQL mode. The precise behavior depends on which, if any, of the strict and NO_ZERO_DATE SQL modes are ... The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and ...
https://dev.mysql.com/doc/refman/9.7/en/declare-condition.html
For a list of MySQL error codes, see Server Error Message Reference. For a list of SQLSTATE values, see Server Error Message Reference. DECLARE condition_name CONDITION FOR condition_value condition_value: { mysql_error_code | SQLSTATE [VALUE] ...
https://dev.mysql.com/doc/refman/9.7/en/document-store-interfaces.html
To work with MySQL as a document store, you use dedicated components and a choice of clients that support communicating with the MySQL server to develop document based applications. You can use MySQL Shell to prototype applications, execute queries ...