Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-features-auto-increment.html
(Bug #45677) An INSERT into a table that has a composite primary key that includes an AUTO_INCREMENT column that is not the first column of this composite key is not safe for statement-based logging or replication. Statement-based replication of ...
https://dev.mysql.com/doc/refman/8.4/en/show-procedure-code.html
For each statement that is taken from source, there is a code word stmt followed by a type (9 means DROP, 5 means INSERT, and so on). SHOW PROCEDURE CODE proc_name This statement is a MySQL extension that is available only for servers that have ...
https://dev.mysql.com/doc/refman/8.4/en/table-locking.html
But because only one session can write to a table at any one time, for best performance with these other storage engines, use them primarily for tables that are queried often and rarely inserted into or updated. To give a specific INSERT, UPDATE, or ... InnoDB tables use row-level locking so that multiple sessions and applications can read from and write to the same table simultaneously, without making each other wait or producing inconsistent ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-date-handling.html
To retrieve temporal values, the procedure is similar, except that you set the buffer_type member to the type of value you expect to receive, and the buffer member to the address of a MYSQL_TIME structure into which the returned value should be ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-info.html
String format: Records: 100 Duplicates: 0 Warnings: 0 INSERT INTO ... String format: Records: 3 Duplicates: 0 Warnings: 0 LOAD DATA String format: Records: 1 Deleted: 0 Skipped: 0 Warnings: 0 ALTER TABLE String format: Records: 3 Duplicates: 0 ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-send-long-data.html
It inserts the data value 'MySQL - The most popular Open Source database' into the text_column column. bool mysql_stmt_send_long_data(MYSQL_STMT *stmt, unsigned int parameter_number, const char *data, unsigned long length) Description Enables an ...
https://dev.mysql.com/doc/c-api/8.4/en/query-results.html
mysql_insert_id() returns the ID generated by the last query that inserted a row into a table with an AUTO_INCREMENT index. In addition to the result set returned by a query, you can also get the following information: mysql_affected_rows() returns ...With mysql_store_result(), mysql_num_rows() may be called as soon as mysql_store_result() ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-model-sharing.html
Import the model the admin user previously exported into the model catalog for user1. This topic describes how to grant other users access to a model you create. Before You Begin Share Your Models Export the Model to Share Set Up Other User with ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-errors.html
It means, if you insert a NULL value into the column, you will get the next integer value for the table's auto_increment counter. #DELETED# Records Reported by Access Access reports records as #DELETED# when inserting or updating records in linked ... The following section details some common errors and their suggested fix or alternative ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-lastrowid.html
For example, if you perform an INSERT into a table that contains an AUTO_INCREMENT column, lastrowid returns the AUTO_INCREMENT value for the new row. Syntax: id = cursor.lastrowid This read-only property returns the value generated for an ...