Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-physical-structure.html
When new records are inserted into an InnoDB clustered index, InnoDB tries to leave 1/16 of the page free for future insertions and updates of the index records. If index records are inserted in a sequential order (ascending or descending), the ...
https://dev.mysql.com/doc/refman/8.4/en/prepare.html
If a parameter is an immediate member of a SELECT list that is part of an INSERT statement, the derived type of the parameter is the type of the corresponding column into which the parameter is inserted. If a parameter is an immediate member of a ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks.html
For example, to grant the priv_repl user account the INSERT privilege to add rows to the cust table in db1, issue the following statement: mysql> GRANT INSERT ON db1.cust TO 'priv_repl'@'%.example.com'; You assign the PRIVILEGE_CHECKS_USER account ... By default, MySQL replication (including Group Replication) does not carry out privilege checks when transactions that were already accepted by another server are applied on a replica or group ...
MySQL 8.4 Reference Manual :: 19.2.1.3 Determination of Safe and Unsafe Statements in Binary Logging
https://dev.mysql.com/doc/refman/8.4/en/replication-rbr-safe-unsafe.html
In addition, an INSERT into a table that has a composite primary key containing an AUTO_INCREMENT column that is not the first column of this composite key is unsafe. Although these functions are not deterministic, they are treated as safe for ...
https://dev.mysql.com/doc/refman/8.4/en/show-warnings.html
mysql> CREATE TABLE t1 (a TINYINT NOT NULL, b CHAR(4)); Query OK, 0 rows affected (0.05 sec) mysql> INSERT INTO t1 VALUES(10,'mysql'), (NULL,'test'), (300,'xyz'); Query OK, 3 rows affected, 3 warnings (0.00 sec) Records: 3 Duplicates: 0 Warnings: 3 ...Warnings are generated for DML statements such as INSERT, UPDATE, and LOAD DATA as well as DDL statements such as CREATE TABLE and ALTER ... SHOW WARNINGS [LIMIT [offset,] row_count] SHOW COUNT(*) WARNINGS SHOW WARNINGS is a diagnostic ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-9-1-0.html
(Bug #113509, Bug #36154975) After using executeBatch() to insert rows into a table and adding more rows with executeUpdate(), getGeneratedKeys() returned the wrong keys for the inserted rows. (Bug #36936407) When using PreparedStatements, negative ... Version 9.1.0 is a new GA release of MySQL ...
https://dev.mysql.com/doc/workbench/en/wb-configuration-additional.html
In addition, enable Use UPPERCASE keywords on completion to code suggest upper case SQL keywords, such as INSERT instead of insert. For example, typing INSERT will load documentation for the INSERT statement in the right panel. Commonly used ...
https://dev.mysql.com/doc/workbench/en/wb-preferences-general-editors.html
Indentation Tab key inserts spaces instead of tabs Indent width: [4] How many spaces to insert when indenting with the tab key. The number of spaces inserted after pressing the Tab key -- this assumes that the Tab key inserts spaces instead of tabs ... This section describes the preference options that apply to general-purpose editors (see the figure that ...
https://dev.mysql.com/doc/relnotes/connector-python/en/news-8-0-32.html
(Bug #108733, Bug #34689812) The MySQLCursor.executemany() method failed to batch insert data because the regular expression (RE) sentinel did not detect batch cases correctly; this meant using a one-on-one insert instead, which led to poor ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-sql-result-sets.html
An SqlResult combines a result set produced by, for example, INSERT, and a data set, produced by, for example, SELECT in one. An SqlResult instance exports methods for accessing data and to retrieving the last inserted ID or number of affected rows.