https://dev.mysql.com/mysql-session-track-get-first.html
int mysql_session_track_get_first(MYSQL *mysql, enum enum_session_state_type type, const char **data, size_t *length) MySQL implements a session tracker mechanism whereby the server returns information about session state changes to clients. To ...
https://dev.mysql.com/mysql-stmt-fetch-column.html
int mysql_stmt_fetch_column(MYSQL_STMT *stmt, MYSQL_BIND *bind, unsigned int column, unsigned long offset) Fetches one column from the current result set row. It should be set up the same way as for mysql_stmt_bind_result(). offset is the offset ...
https://dev.mysql.com/mysql-stmt-field-count.html
unsigned int mysql_stmt_field_count(MYSQL_STMT *stmt) Returns the number of columns for the most recent statement for the statement handler. An unsigned integer representing the number of columns in a result set. This value is zero for statements ...
https://dev.mysql.com/mysql-stmt-param-count.html
unsigned long mysql_stmt_param_count(MYSQL_STMT *stmt) Returns the number of parameter markers present in the prepared statement. An unsigned long integer representing the number of parameters in a statement.
https://dev.mysql.com/mysql-stmt-send-long-data.html
bool mysql_stmt_send_long_data(MYSQL_STMT *stmt, unsigned int parameter_number, const char *data, unsigned long length) Enables an application to send parameter data to the server in pieces (or “chunks”). It can be called multiple times to send ...
https://dev.mysql.com/optimizing-innodb-bulk-data-loading.html
For optimal performance when loading data into an InnoDB FULLTEXT index, follow this set of steps: Define a column FTS_DOC_ID at table creation time, of type BIGINT UNSIGNED NOT NULL, with a unique index named FTS_DOC_ID_INDEX. For example: CREATE ... These performance tips supplement the general guidelines for fast inserts in Section 8.2.5.1, “Optimizing INSERT ...
https://dev.mysql.com/partitioning-limitations.html
This section discusses current restrictions and limitations on MySQL partitioning support. The following constructs are not permitted in partitioning expressions: Stored procedures, stored functions, UDFs, or plugins. For a list of SQL functions ...
https://dev.mysql.com/performance-schema-functions.html
PS_CURRENT_THREAD_ID() Returns a BIGINT UNSIGNED value representing the Performance Schema thread ID assigned to the current connection. PS_THREAD_ID(connection_id) Given a connection ID, returns a BIGINT UNSIGNED value representing the Performance ... As of MySQL 8.0.16, MySQL includes built-in SQL functions that format or retrieve Performance Schema data, and that may be used as equivalents for the corresponding sys schema stored ...
https://dev.mysql.com/replace.html
REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] {VALUES | VALUE} (value_list) [, (value_list)] ... REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION ...
https://dev.mysql.com/server-error-reference.html
Error number: 3859; Symbol: ER_WARN_DEPRECATED_FLOAT_UNSIGNED; SQLSTATE: HY000 Message: UNSIGNED for decimal and floating point data types is deprecated and support for it will be removed in a future release. Error number: 3956; Symbol: ... The ...
