Search Results
https://dev.mysql.com/doc/refman/8.4/en/binary-varbinary.html
For cases of truncation, to cause an error to occur (rather than a warning) and suppress insertion of the value, use strict SQL mode. Values are right-padded with 0x00 for inserts, and no trailing bytes are removed for retrievals. Example: For a ...
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 ...
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. But eventually they try to insert a rarer Chinese character and it does not work. mysql> SET sql_mode = ''; mysql> INSERT ... 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/8.4/en/federated-usagenotes.html
Internally, the implementation uses SELECT, INSERT, UPDATE, and DELETE, but not HANDLER. The FEDERATED storage engine supports SELECT, INSERT, UPDATE, DELETE, TRUNCATE TABLE, and indexes. FEDERATED performs bulk-insert handling such that multiple ...
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. If one session has a shared or ...
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. The work of performing the inserts is parallelized across the threads in the data nodes involved. Otherwise, any trailing spaces are ... The NDB Cluster restoration program is implemented as a separate command-line utility ndb_restore, which can normally be found in the MySQL bin ...
https://dev.mysql.com/doc/refman/8.4/en/optimizer-hints.html
The parser recognizes optimizer hint comments after the initial keyword of SELECT, UPDATE, INSERT, REPLACE, and DELETE statements. Examples: SELECT /*+ RESOURCE_GROUP(USR_default) */ name FROM people ORDER BY name; INSERT /*+ RESOURCE_GROUP(Batch) ... One means of control over optimizer strategies is to set the optimizer_switch system variable (see Section 10.9.2, “Switchable ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-exchange.html
In addition to the ALTER, INSERT, and CREATE privileges usually required for ALTER TABLE statements, you must have the DROP privilege to perform ALTER TABLE ... To see how this occurs, first insert a row into e2 that is outside the boundaries of the ...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
In the event that the target type cannot represent the value being inserted, a decision must be made on how to handle the conversion. Lossy conversion is handled by inserting only the first N characters of the string on the replica, where N is the ... Source and target tables for replication do not have to be ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-source.html
The highest value present in the col column prior to the INSERT is 31, and the next available value in the AUTO_INCREMENT series is 35, so the inserted values for col begin at that point and the results are as shown for the SELECT query. If the ...