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
This section provides a conceptual overview of partitioning in MySQL 8.0. For information on partitioning restrictions and feature limitations, see Section 23.6, “Restrictions and Limitations on Partitioning”. The SQL standard does not provide ...
https://dev.mysql.com/partitioning-types.html
However, you can use other date and time functions that return an integer or NULL, such as WEEKDAY(), DAYOFYEAR(), or MONTH(). This section discusses the types of partitioning which are available in MySQL 8.0. This type of partitioning assigns rows ...
https://dev.mysql.com/creating-tables.html
You want a table that contains a record for each of your pets. This can be called the pet table, and it should contain, as a bare minimum, each animal's name. Because the name by itself is not very interesting, the table should contain other ...
https://dev.mysql.com/password-management.html
MySQL supports these password-management capabilities: Password expiration, to require passwords to be changed periodically. Password reuse restrictions, to prevent old passwords from being chosen again. Password verification, to require that ...
https://dev.mysql.com/server-system-variables.html
lc_time_names Property Value Command-Line Format --lc-time-names=value System Variable lc_time_names Scope Global, Session Dynamic Yes SET_VAR Hint Applies No Type String This variable specifies the locale that controls the language used to display ... The MySQL server maintains many system variables that configure its ...
https://dev.mysql.com/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Reserved words are permitted as ...
https://dev.mysql.com/mysql-stmt-fetch.html
int mysql_stmt_fetch(MYSQL_STMT *stmt) mysql_stmt_fetch() returns the next row in the result set. It can be called only while the result set exists; that is, after a call to mysql_stmt_execute() for a statement such as SELECT that produces a result ...
https://dev.mysql.com/c-api-prepared-statement-date-handling.html
mysql_stmt_bind_param(stmt, bind); /* supply the data to be sent in the ts structure */ ts.year= 2002; ts.month= 02; ts.day= 03; ts.hour= 10; ts.minute= 45; ts.second= 20; mysql_stmt_execute(stmt); .. The binary (prepared statement) protocol ...
https://dev.mysql.com/merge-table-advantages.html
For example, you can put data from different months into separate tables, compress some of them with myisampack, and then create a MERGE table to use them as one. MERGE tables can help you solve the following problems: Easily manage a set of log ...
