Search Results
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/mysql-em-plugin/en/myoem-config-metric-connectionbuffers-category.html
Table 7.8 Connection Buffers Configuration Metrics NameDescriptionBulk Insert Buffer Size Limits the size (in bytes) of the special tree-like cache MyISAM uses to make bulk inserts faster for INSERT ... Lists the Connection Buffers configuration ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/ui-security-advisor-ref.html
Global privileges such as DROP, ALTER, DELETE, UPDATE, INSERT, and LOCK TABLES may be dangerous as they may cause other users to be affected adversely. This advisor enables you to define a regular expression describing the users allowed to have ...
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.
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/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.