https://dev.mysql.com/account-categories.html
As of MySQL 8.0.16, MySQL incorporates the concept of user account categories, based on the SYSTEM_USER privilege. The SYSTEM_USER privilege has an effect on the accounts to which a given user can apply its other privileges, as well as whether the ...
https://dev.mysql.com/archive-storage-engine.html
The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small footprint. To enable this storage engine if you build MySQL from source, invoke CMake with the -DWITH_ARCHIVE_STORAGE_ENGINE ...
https://dev.mysql.com/arithmetic-functions.html
Discards from the division result any fractional part to the right of the decimal point. Table 12.8 Arithmetic Operators Name Description %, MOD Modulo operator * Multiplication operator + Addition operator - Minus operator - Change the sign of the ...
https://dev.mysql.com/backup-and-recovery.html
It is important to back up your databases so that you can recover your data and be up and running again in case problems occur, such as system crashes, hardware failures, or users deleting data by mistake. Backups are also essential as a safeguard ...
https://dev.mysql.com/c-api-binary-log-data-structures.html
C API functions for processing a replication event stream from a server require a connection handler (a MYSQL * pointer) and a pointer to a MYSQL_RPL structure that describes the steam of replication events to read from the server binary log. The ...int result = mysql_binlog_open(mysql, &rpl); This section describes the MYSQL_RPL structure ...
https://dev.mysql.com/c-api-prepared-statement-function-overview.html
At that point the handler becomes invalid and should no longer be used. The following list summarizes the functions available for prepared statement processing. For greater detail, see the descriptions in Section 28.6.10, “C API Prepared ...
https://dev.mysql.com/c-api-prepared-statement-problems.html
When converting a floating-point number to a string in the client, the rightmost digits of the converted value may differ slightly from those of the original value. Here follows a list of the currently known problems with prepared statements: TIME, ...
https://dev.mysql.com/c-api-prepared-statement-type-conversions.html
Here are some examples: If you use MYSQL_TYPE_LONG with an int variable to pass an integer value to the server that is to be stored into a FLOAT column, MySQL converts the value to floating-point format before storing it. Prepared statements ...
https://dev.mysql.com/case.html
For the second syntax, each WHEN clause search_condition expression is evaluated until one is true, at which point its corresponding THEN clause statement_list executes. CASE case_value WHEN when_value THEN statement_list [WHEN when_value THEN ...
https://dev.mysql.com/changing-mysql-user.html
If it does not, you will also need to follow those links and change the directories and files they point to. On Windows, you can run the server as a Windows service using a normal user account. On Linux, for installations performed using a MySQL ...
