https://dev.mysql.com/binary-log.html
You can use the --log-bin option to specify an alternative location, by adding a leading absolute path name to the base name to specify a different directory. The binary log contains “events” that describe database changes such as table ...
https://dev.mysql.com/c-api-prepared-statement-problems.html
When converting an integer to string, ZEROFILL is honored with prepared statements in some cases where the MySQL server does not print the leading zeros. Here follows a list of the currently known problems with prepared statements: TIME, TIMESTAMP, ...
https://dev.mysql.com/charset-syntax.html
The description in the following sections may appear complex, but it has been found in practice that multiple-level defaulting leads to natural and obvious results. There are default settings for character sets and collations at four levels: ...
https://dev.mysql.com/charset-unicode-conversion.html
Also, keep in mind the general principle that if a table has different definitions on the master and slave, this can lead to unexpected results. This section describes issues that you may face when converting character data between the utf8mb3 and ...
https://dev.mysql.com/charset-unicode-sets.html
For _bin collations except utf8mb4_0900_bin, the weight is based on the code point, possibly with leading zero bytes added. This section describes the collations available for Unicode character sets and their differentiating properties. MySQL ...
https://dev.mysql.com/client-connections.html
To accommodate a large number of simultaneous connections, the stack size per thread must be kept small, leading to a situation where it is either too small or the server consumes large amounts of memory. This section describes aspects of how the ...
https://dev.mysql.com/command-line-options.html
(However, the leading dashes cannot be given as underscores.) For options that take a numeric value, the value can be given with a suffix of K, M, or G to indicate a multiplier of 1024, 10242 or 10243. Program options specified on the command line ...
https://dev.mysql.com/comparison-operators.html
Whether a value is not within a range of values !=, <> Not equal operator NOT IN() Whether a value is not within a set of values NOT LIKE Negation of simple pattern matching STRCMP() Compare two strings Comparison operations result in a value of 1 ...
https://dev.mysql.com/create-index.html
CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... This guideline is especially important for InnoDB tables, where the primary key determines the ...
https://dev.mysql.com/create-procedure.html
Declaring a nondeterministic routine as DETERMINISTIC might lead to unexpected results by causing the optimizer to make incorrect execution plan choices. To associate the routine explicitly with a given database, specify the name as db_name.sp_name ...
