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-options-binary-log.html
--binlog-do-db=db_name Command-Line Format --binlog-do-db=name Type String This option affects binary logging in a manner similar to the way that --replicate-do-db affects replication. --binlog-ignore-db=db_name Command-Line Format ... Startup ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-overview.html
The user-selected rule by which the division of data is accomplished is known as a partitioning function, which in MySQL can be the modulus, simple matching against a set of ranges or value lists, an internal hashing function, or a linear hashing ...
https://dev.mysql.com/doc/refman/5.7/en/upgrade-troubleshooting.html
If you have created a loadable function with a given name and upgrade MySQL to a version that implements a new built-in function with the same name, the loadable function becomes inaccessible. To correct this, use DROP FUNCTION to drop the loadable ... If problems occur, such as that the new mysqld server does not start, verify that you do not have an old my.cnf file from your previous ...
https://dev.mysql.com/doc/refman/5.7/en/insert.html
SELECT, the statement returns an information string in this format: Records: N1 Duplicates: N2 Warnings: N3 If you are using the C API, the information string can be obtained by invoking the mysql_info() function. For example, inserting the string ... INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] {VALUES | VALUE} (value_list) [, (value_list)] ...
https://dev.mysql.com/doc/refman/5.7/en/sys-format-statement.html
Given a string (normally representing an SQL statement), reduces it to the length given by the statement_truncate_len configuration option, and returns the result. Otherwise, the middle part of the string is replaced by an ellipsis (...). This ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rbr-safe-unsafe.html
However, certain nondeterministic functions are not considered unsafe (see Nondeterministic functions not considered unsafe, later in this section). In addition, statements using results from floating-point math functions—which are ... The ...
https://dev.mysql.com/doc/refman/5.7/en/sys-extract-schema-from-file-name.html
This function assumes that the file name lies within the schema directory. This function is useful when extracting file I/O information from the Performance Schema that includes file path names. Given a file path name, returns the path component ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-is-consumer-enabled.html
(Prior to MySQL 5.7.28, the function returns NULL if the argument is not a valid consumer name.) This function accounts for the consumer hierarchy, so a consumer is not considered enabled unless all consumers on which depends are also enabled.
https://dev.mysql.com/doc/refman/5.7/en/audit-log-file-reading.html
audit_log_read() takes an optional JSON string argument, and the result returned from a successful call to either function is a JSON string. The audit log plugin supports functions that provide an SQL interface for reading JSON-format audit log ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-generated-columns.html
Generated column definitions have this syntax: col_name data_type [GENERATED ALWAYS] AS (expr) [VIRTUAL | STORED] [NOT NULL | NULL] [UNIQUE [KEY]] [[PRIMARY] KEY] [COMMENT 'string'] AS (expr) indicates that the column is generated and defines the ...