Search Results
https://dev.mysql.com/doc/connectors/en/connector-net-programming-mysqlcommand.html
The MySqlCommand class represents a SQL statement to execute against a MySQL database. An instance of MySqlCommand can be organized to execute as a prepared statement for faster excecution and reuse, or as a stored procedure. The remainder of this ...Class methods enable you to perform the following database operations: Query a database Insert, update, and delete data Return a single value Command-based database operations can run within a transaction, if ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-mysqlcommand.html
The MySqlCommand class represents a SQL statement to execute against a MySQL database. An instance of MySqlCommand can be organized to execute as a prepared statement for faster excecution and reuse, or as a stored procedure. The remainder of this ...Class methods enable you to perform the following database operations: Query a database Insert, update, and delete data Return a single value Command-based database operations can run within a transaction, if ...
https://dev.mysql.com/doc/relnotes/connector-cpp/en/news-8-0-26.html
This capability is implemented using type-specific methods for the sql::Statement class: int Statement::setQueryAttrInt(attr_name, int_value); int Statement::setQueryAttrString(attr_name, str_value); int Statement::setQueryAttrBoolean(attr_name, ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-mysqlserver-instanceactivity-category.html
(The maximum number of statements is given by the max_prepared_stmt_count system variable.). This variable includes statements executed within stored programs, unlike the Questions variable. Queries (Per Second) The average number of statements ...
https://dev.mysql.com/doc/heatwave/en/heatwave-errors.html
SELECT` statements using HeatWave tables are not supported when binlog_format is set to STATEMENT. SELECT` statements using HeatWave tables Error number: 1119; Symbol: HW_ER_INCOMPATIBLE_DATA_TYPES_IN_BINARY_EXPR Message: Type, [%s], is not ... The ...
https://dev.mysql.com/doc/refman/8.4/en/assigning-passwords.html
If the read_only system variable is enabled, use of account-modification statements such as CREATE USER or ALTER USER additionally requires the CONNECTION_ADMIN privilege (or the deprecated SUPER privilege). The discussion here summarizes syntax ...
https://dev.mysql.com/doc/refman/8.4/en/federated-description.html
The statement is sent to the remote server using the MySQL client API. The remote server processes the statement and the local server retrieves any result that the statement produces (an affected-rows count or a result set). If the statement ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-ro-txn.html
Eliminating unnecessary transaction IDs reduces the size of internal data structures that are consulted each time a query or data change statement constructs a read view. InnoDB detects read-only transactions when: The transaction is started with ...
https://dev.mysql.com/doc/refman/8.4/en/internal-locking.html
FOR UPDATE statement for each group of rows expected to be modified, even if the data change statements come later in the transaction. If transactions modify or lock more than one table, issue the applicable statements in the same order within each ... This section discusses internal locking; that is, locking performed within the MySQL server itself to manage contention for table contents by multiple ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-options.html
Performance Schema parameters can be specified at server startup on the command line or in option files to configure Performance Schema instruments and consumers. Runtime configuration is also possible in many cases (see Section 29.4, ...