Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-connection.html
The mysql, mysqladmin, mysqlcheck, mysqlimport, and mysqlshow client programs determine the default character set to use as follows: In the absence of other information, each client uses the compiled-in default character set, usually utf8mb4. A ...
https://dev.mysql.com/doc/refman/8.4/en/charset-cp932.html
Because MySQL supports character set conversion, it is important to separate IANA Shift_JIS and cp932 into two different character sets because they provide different conversion rules. Why is cp932 needed? In MySQL, the sjis character set ...
https://dev.mysql.com/doc/refman/8.4/en/checksum-table.html
Important If the checksums for two tables are different, then it is almost certain that the tables are different in some way. [QUICK | EXTENDED] CHECKSUM TABLE reports a checksum for the contents of a table. You can use this statement to verify that ...
https://dev.mysql.com/doc/refman/8.4/en/choosing-types.html
If accuracy is not too important or if speed is the highest priority, the DOUBLE type may be good enough. For optimum storage, you should try to use the most precise type in all cases. For example, if an integer column is used for values in the ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-concurrent-ddl.html
DDL operations that are not permitted during a cloning operation regardless of the clone_block_ddl setting include: ALTER TABLE tbl_name DISCARD TABLESPACE; ALTER TABLE tbl_name IMPORT TABLESPACE; ALTER INSTANCE DISABLE INNODB REDO_LOG; . In MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-failure-handling.html
If the data is of importance, a backup should be taken before initiating a remote cloning operation. This section describes failure handing at different stages of a cloning operation. If a failure occurs during the prerequisite check, the CLONE ...
https://dev.mysql.com/doc/refman/8.4/en/commit.html
Important Many APIs used for writing MySQL client applications (such as JDBC) provide their own methods for starting transactions that can (and sometimes should) be used instead of sending a START TRANSACTION statement from the client. SET ...
https://dev.mysql.com/doc/refman/8.4/en/components.html
For example, if you intend to write your own components, this information is important for understanding how components work. MySQL Server includes a component-based infrastructure for extending server capabilities. A component provides services ...
https://dev.mysql.com/doc/refman/8.4/en/copying-databases.html
After you import the mysql database on the new machine, execute mysqladmin flush-privileges so that the server reloads the grant table information. In cases where you need to transfer databases between different architectures, you can use mysqldump ...
https://dev.mysql.com/doc/refman/8.4/en/corrupted-myisam-tables.html
The most important thing to know is whether the table became corrupted as a result of an unexpected server exit. Even though the MyISAM table format is very reliable (all changes to a table made by an SQL statement are written before the statement ...