Search Results
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-last-insert-id.html
The final example shows how updatable result sets can retrieve the AUTO_INCREMENT value when using the insertRow() method. getGeneratedKeys() is the preferred method to use if you need to retrieve AUTO_INCREMENT keys and through JDBC; this is ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-performanceschema-activity-category.html
Table Instances Lost (Delta) How many instances of object type table could not be created. Table 6.22 Performance Schema Activity Metrics NameDescriptionCond Classes Lost (Delta) How many instruments of type cond could not be loaded. Cond Instances ... Lists the Performance Schema Activity metrics and provides a brief description of ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-last-insert-id.html
The final example shows how updatable result sets can retrieve the AUTO_INCREMENT value when using the insertRow() method. getGeneratedKeys() is the preferred method to use if you need to retrieve AUTO_INCREMENT keys and through JDBC; this is ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-background.html
An InnoDB table created with ROW_FORMAT=COMPRESSED can use a smaller page size on disk than the configured innodb_page_size value. The compressed page size is specified through the CREATE TABLE or ALTER TABLE KEY_BLOCK_SIZE parameter. Specify a ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-audit-plugins.html
To demonstrate use of those system variables, suppose that a table db1.t1 exists, created as follows: CREATE DATABASE db1; CREATE TABLE db1.t1 (a VARCHAR(255)); For test-creation purposes, it is possible to record events that pass through the plugin. Additionally, several places in the server call the audit interface when an auditable event occurs, so that registered audit plugins can be notified about the event if ...
https://dev.mysql.com/doc/refman/8.4/en/replication-sbr-rbr.html
SELECT, a CREATE statement is generated from the table definition and replicated using statement-based format, while the row insertions are replicated using row-based format. (Row-based replication, however, simply replicates the value returned by ...For most users, the mixed replication format should provide the best combination of data integrity and ...
https://dev.mysql.com/doc/refman/8.4/en/values.html
VALUES is a DML statement which returns a set of one or more rows as a table. In other words, it is a table value constructor which also functions as a standalone SQL statement. You should also bear in mind that ROW() is a row value constructor ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-programming-net.html
5.6.7.2.1 Using Connector/ODBC with ODBC.NET and C# (C sharp) The following sample creates a table my_odbc_net and demonstrates its use in C#. This section contains simple examples that demonstrate the use of Connector/ODBC drivers with ODBC.NET.
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-statementprocessing-category.html
Quote Show Create Enabled If set to 1 (the default), the server quotes identifiers for SHOW CREATE TABLE and SHOW CREATE DATABASE statements. Buffer Result Enabled If set to 1, sql_buffer_result forces results from SELECT statements to be put into ... Lists the Statement Processing configuration metrics and provides a brief description of ...
https://dev.mysql.com/doc/refman/8.4/en/federated-create-connection.html
To use the first method, you must specify the CONNECTION string after the engine type in a CREATE TABLE statement. For example: CREATE TABLE federated_table ( id INT(20) NOT NULL AUTO_INCREMENT, name VARCHAR(32) NOT NULL DEFAULT '', other INT(20) ...The CONNECTION string contains the information required to connect to the remote server containing the table in which the data physically ...The format of the ...