https://dev.mysql.com/mysql-server-init.html
int mysql_server_init(int argc, char **argv, char **groups) This function initializes the MySQL client library, which must be done before you call any other MySQL function. Note To avoid memory leaks after the application is done using the library ...
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/mysqldump.html
It is not intended as a fast or scalable solution for backing up substantial amounts of data. If you are using a recent version of mysqldump to generate a dump to be reloaded into a very old MySQL server, use the --skip-opt option instead of the ...
https://dev.mysql.com/numeric-type-syntax.html
For integer data types, M indicates the maximum display width. For floating-point and fixed-point data types, M is the total number of digits that can be stored. As of MySQL 8.0.17, the display width attribute is deprecated for integer data types ...Display width is unrelated to the range of values a type can store, as described in Section 11.1.6, “Numeric Type ...
https://dev.mysql.com/partitioning-info.html
This section discusses obtaining information about existing partitions, which can be done in a number of ways. Methods of obtaining such information include the following: Using the SHOW CREATE TABLE statement to view the partitioning clauses used ...
https://dev.mysql.com/partitioning-management-hash-key.html
Tables which are partitioned by hash or by key are very similar to one another with regard to making changes in a partitioning setup, and both differ in a number of ways from tables which have been partitioned by range or list. For that reason, ...
https://dev.mysql.com/partitioning-overview.html
The SQL language itself is intended to work independently of any data structures or media underlying the schemas, tables, rows, or columns with which it works. The user-selected rule by which the division of data is accomplished is known as a ...
https://dev.mysql.com/partitions-table.html
The indexing can change as partitions are added, dropped, and reorganized; the number shown is this column reflects the current order, taking into account any indexing changes. For a RANGE partition, it contains the value set in the partition's ...
https://dev.mysql.com/performance-schema-transaction-tables.html
CREATE TABLE t2 (a INT) ENGINE = MyISAM; -- Transaction 1 COMMIT -- (implicit; DDL forces commit) 6. INSERT INTO t2 VALUES (1), (2), (3); -- Update nontransactional table 7. INSERT INTO t1 VALUES (4), (5), (6); -- Write to transactional table -- ...
https://dev.mysql.com/precision-math-examples.html
The floating-point calculation introduces small errors: +--------+------------------+ | d | f | +--------+------------------+ | 1.0000 | 0.99999999999991 | +--------+------------------+ Example 2. Rounding for exact-value columns (DECIMAL and ...
