https://dev.mysql.com/mysql-shell-tutorial-python-documents-remove.html
mysql-py> db.countryinfo.remove(True).limit(1) Query OK, 1 item affected (0.03 sec) The following example removes the last document in the countryinfo collection by country name. mysql-py> db.countryinfo.remove(True).sort(["Name desc"]).limit(1) ...
https://dev.mysql.com/mysqlbinlog.html
mysqlbinlog sets the value of pseudo_slave_mode to true before executing any SQL statements. If this option is given twice (by passing in either "-vv" or "--verbose --verbose"), the output includes comments to indicate column data types and some ...
https://dev.mysql.com/string-comparison-functions.html
The same is true for aggregate queries involving NULL and comparisons using NOT RLIKE or NOT REGEXP. Table 12.8 String Comparison Functions and Operators Name Description LIKE Simple pattern matching NOT LIKE Negation of simple pattern matching ...
https://dev.mysql.com/sys-ps-trace-thread.html
Dumps all Performance Schema data for an instrumented thread to a .dot formatted graph file (for the DOT graph description language). Each result set returned from the procedure should be used for a complete graph. This procedure disables binary ...
https://dev.mysql.com/threads-table.html
That is not true of the threads table; all rows are shown to any user who has the SELECT privilege for the table. For monitoring of events executed by the thread to occur, these things must be true: The thread_instrumentation consumer in the ... The ...
https://dev.mysql.com/view-check-option.html
The WITH CHECK OPTION clause can be given for an updatable view to prevent inserts to rows for which the WHERE clause in the select_statement is not true. It also prevents updates to rows for which the WHERE clause is true but the update would ...
https://dev.mysql.com/audit-log-installation.html
This section describes how to install or uninstall MySQL Enterprise Audit, which is implemented using the audit log plugin and related components described in Section 6.4.5.1, “Audit Log Components”. For general information about installing ...
https://dev.mysql.com/charset-unicode-sets.html
This section describes the collations available for Unicode character sets and their differentiating properties. MySQL supports multiple Unicode character sets: utf8mb4: A UTF-8 encoding of the Unicode character set using one to four bytes per ...
https://dev.mysql.com/date-and-time-functions.html
This section describes the functions that can be used to manipulate temporal values. See Section 11.3, “Date and Time Types”, for a description of the range of values each date and time type has and the valid formats in which values may be ...
https://dev.mysql.com/declare-handler.html
This is true even if the condition occurs in an inner block. statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The ...
