https://dev.mysql.com/mysql-stat.html
const char *mysql_stat(MYSQL *mysql) Returns a character string containing information similar to that provided by the mysqladmin status command. This includes uptime in seconds and the number of running threads, questions, reloads, and open tables. CR_SERVER_LOST The connection to the server was lost during the ...
https://dev.mysql.com/mysql-stmt-error.html
const char *mysql_stmt_error(MYSQL_STMT *stmt) For the statement specified by stmt, mysql_stmt_error() returns a null-terminated string containing the error message for the most recently invoked statement API function that can succeed or fail.
https://dev.mysql.com/mysql-stmt-prepare.html
int mysql_stmt_prepare(MYSQL_STMT *stmt, const char *stmt_str, unsigned long length) Given the statement handler returned by mysql_stmt_init(), prepares the SQL statement pointed to by the string stmt_str and returns a status value. The application ...You should not add a terminating semicolon (;) or \g to the ...
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 ...data is a pointer to a buffer containing data to be sent, and length indicates the number of bytes in the ...
https://dev.mysql.com/mysql-stmt-sqlstate.html
const char *mysql_stmt_sqlstate(MYSQL_STMT *stmt) For the statement specified by stmt, mysql_stmt_sqlstate() returns a null-terminated string containing the SQLSTATE error code for the most recently invoked prepared statement API function that can ..."00000" means “no error.” The values are specified by ANSI SQL and ...
https://dev.mysql.com/numeric-type-attributes.html
For example, applications could use the LPAD() function to zero-pad numbers up to the desired width, or they could store the formatted numbers in CHAR columns. MySQL supports an extension for optionally specifying the display width of integer data ...
https://dev.mysql.com/numeric-type-syntax.html
For example, applications could use the LPAD() function to zero-pad numbers up to the desired width, or they could store the formatted numbers in CHAR columns. For integer data types, M indicates the maximum display width. Display width is ...
https://dev.mysql.com/order-by-optimization.html
For example, if only the first 10 bytes of a CHAR(20) column are indexed, the index cannot distinguish values past the 10th byte and a filesort is needed. Separate the paths by colon characters (:) on Unix and semicolon characters (;) on Windows.
https://dev.mysql.com/partitioning-columns.html
The next two sections discuss COLUMNS partitioning, which are variants on RANGE and LIST partitioning. COLUMNS partitioning enables the use of multiple columns in partitioning keys. All of these columns are taken into account both for the purpose ...
https://dev.mysql.com/partitioning-hash.html
Partitioning by HASH is used primarily to ensure an even distribution of data among a predetermined number of partitions. To partition a table using HASH partitioning, it is necessary to append to the CREATE TABLE statement a PARTITION BY HASH ...
