Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-restore.html
This program reads the files created as a result of the backup and inserts the stored information into the database. Otherwise, any trailing spaces are dropped from such column values when they are inserted into the new columns. You should use this ...--num-slices=# Command-Line Format --num-slices=# Type Integer Default Value 1 Minimum Value 1 Maximum Value 1024 When restoring a backup by slices, this option sets the number of slices into which to divide the ...
MySQL 8.4 Reference Manual :: A.11 MySQL 8.4 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
https://dev.mysql.com/doc/refman/8.4/en/faqs-cjk.html
Sometimes people try to insert gbk characters into gb2312, and it works most of the time because gbk is a superset of gb2312. mysql> SET sql_mode = ''; mysql> INSERT INTO ch VALUES ('A汌B','A汌B'); Query OK, 1 row affected, 1 warning (0.00 sec) ...
https://dev.mysql.com/doc/refman/8.4/en/optimizer-hints.html
Examples: SELECT /*+ RESOURCE_GROUP(USR_default) */ name FROM people ORDER BY name; INSERT /*+ RESOURCE_GROUP(Batch) */ INTO t2 VALUES(2); Syntax of the RESOURCE_GROUP hint: RESOURCE_GROUP(group_name) group_name indicates the resource group to which ...The parser recognizes optimizer hint comments after the initial keyword of SELECT, UPDATE, INSERT, REPLACE, and DELETE ... One means of control ...
https://dev.mysql.com/doc/internals/en/x-protocol-messages-messages.html
If the server adds more internal data types that rely on BLOB storage like image manipulation, seeking into complex types in BLOBs, and more types will be added. Topics in this section: Message Structure Message Sequence Common Messages Connection ...
https://dev.mysql.com/doc/refman/8.4/en/ansi-diff-foreign-keys.html
In an SQL statement that inserts, deletes, or updates many rows, foreign key constraints (like unique constraints) are checked row-by-row. In that case, a (child table) row containing such a foreign key can be inserted even though it does not match ...For example, if you define a RESTRICT type constraint, and there is a child row with several parent rows, InnoDB does not permit the deletion of any of the parent ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-exchange.html
To see how this occurs, first insert a row into e2 that is outside the boundaries of the partition definition for partition p0 of table e. In addition to the ALTER, INSERT, and CREATE privileges usually required for ALTER TABLE statements, you must ...Table nt contains no foreign key references, and no other table has any foreign keys that refer to ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-differing-tables.html
When inserting a value from a BIT(M) column into a BIT(M') column, where M' > M, the most significant bits of the BIT(M') columns are cleared (set to zero) and the M bits of the BIT(M) value are set as the least significant bits of the BIT(M') ...In ... Source and target tables for replication do not have to be ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-source.html
If the local value is set, the new value affects AUTO_INCREMENT columns for all tables into which new rows are inserted by the current user for the duration of the session, unless the values are changed during that session. The highest value present ... This section describes the server options and system variables that you can use on replication source ...
https://dev.mysql.com/doc/refman/8.4/en/blackhole-storage-engine.html
Inserts into a BLACKHOLE table do not store any data, but if statement based binary logging is enabled, the SQL statements are logged and replicated to replica servers. Inserts are performed into the source's table without explicitly setting the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-next-key-locking.html
If the locks set on the index records in the scanned range do not lock out inserts made in the gaps (in this case, the gap between 90 and 102), another session can insert a new row into the table with an id of 101. Just that happens in the preceding ...If one session has a shared or exclusive lock on record R in an index, another session cannot insert a new index record in the gap immediately before R in the index ...