PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-features-variables.html
To help reduce possible confusion, we recommend that you always use the same setting for the lower_case_table_names system variable on both source and replica, especially when you are running MySQL on platforms with case-sensitive file systems.
https://dev.mysql.com/doc/refman/5.7/en/replication-rbr-safe-unsafe.html
When executed against a table that contains more than one primary or unique key, this statement is considered unsafe, being sensitive to the order in which the storage engine checks the keys, which is not deterministic, and on which the choice of ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rules.html
Note All replication filtering options follow the same rules for case sensitivity that apply to names of databases and tables elsewhere in the MySQL server, including the effects of the lower_case_table_names system variable. If a replication ...
https://dev.mysql.com/doc/refman/5.7/en/secure-client-programming.html
Client applications that access MySQL should use the following guidelines to avoid interpreting external data incorrectly or exposing sensitive information. Handle External Data Properly Handle MySQL Error Messages Properly Handle External Data ...
https://dev.mysql.com/doc/refman/5.7/en/select-into.html
SELECT id, data INTO @x, @y FROM test.t1 LIMIT 1; User variable names are not case-sensitive. INTO form of SELECT enables a query result to be stored in variables or written to a file: SELECT ... Column and line terminators can be specified to ...
https://dev.mysql.com/doc/refman/5.7/en/server-loadable-functions.html
MySQL supports loadable functions, that is, functions that are not built in but can be loaded at runtime (either during startup or later) to extend server capabilities, or unloaded to remove capabilities. For a table describing the available ...
https://dev.mysql.com/doc/refman/5.7/en/server-options.html
When you start the mysqld server, you can specify program options using any of the methods described in Section 4.2.2, “Specifying Program Options”. The most common methods are to provide options in an option file or on the command line.
https://dev.mysql.com/doc/refman/5.7/en/server-plugins.html
MySQL supports an plugin API that enables creation of server plugins. Plugins can be loaded at server startup, or loaded and unloaded at runtime without restarting the server. The plugins supported by this interface include, but are not limited to, ...
https://dev.mysql.com/doc/refman/5.7/en/set.html
For binary or case-sensitive collations, lettercase is taken into account when assigning values to the column. A SET is a string object that can have zero or more values, each of which must be chosen from a list of permitted values specified when ...
https://dev.mysql.com/doc/refman/5.7/en/sorting-rows.html
You can force a case-sensitive sort for a column by using BINARY like so: ORDER BY BINARY col_name. You may have noticed in the preceding examples that the result rows are displayed in no particular order. It is often easier to examine query output ...