https://dev.mysql.com/mysql-shell-tutorial-python-documents-collections.html
When you are using MySQL as a Document Store, collections are containers within a schema that you can create, list, and drop. Collections contain JSON documents that you can add, find, update, and remove. The examples in this section use the ...
https://dev.mysql.com/mysql-shell-tutorial-python-documents-modify.html
mysql-py> db.countryinfo.modify("true").set("Airports", []) Query OK, 240 items affected (0.07 sec) With the Airports field added, the next example uses the array_append() method to add a new airport to one of the documents. You can use the ...
https://dev.mysql.com/mysql-stmt-fetch.html
If a fetched data value is a NULL value, the *is_null value of the corresponding MYSQL_BIND structure contains TRUE (1). int mysql_stmt_fetch(MYSQL_STMT *stmt) mysql_stmt_fetch() returns the next row in the result set. It can be called only while ...
https://dev.mysql.com/mysql-stmt-next-result.html
However, this function does not change the connection state, so if it returns true, you must still call mysql_stmt_next_result() to advance to the next result. int mysql_stmt_next_result(MYSQL_STMT *mysql) This function is used when you use ...
https://dev.mysql.com/mysqladmin.html
This is true even if you precede the password command with flush-privileges on the same command line to re-enable the grant tables because the flush operation occurs after you connect. You can use it to check the server's configuration and current ...
https://dev.mysql.com/mysqlbinlog-row-events.html
The following examples illustrate how mysqlbinlog displays row events that specify data modifications. These correspond to events with the WRITE_ROWS_EVENT, UPDATE_ROWS_EVENT, and DELETE_ROWS_EVENT type codes. The --base64-output=DECODE-ROWS and ...
https://dev.mysql.com/mysqlcheck.html
(This is also true for the MySQL upgrade procedure if it determines that table checking is needed because it processes tables the same way.) mysqlcheck must be used when the mysqld server is running, which means that you do not have to stop the ...
https://dev.mysql.com/mysqld-safe.html
(See Section 2.1.4, “Installation Layouts”.) mysqld_safe expects one of the following conditions to be true: The server and databases can be found relative to the working directory (the directory from which mysqld_safe is invoked). mysqld_safe ...
https://dev.mysql.com/mysqldump.html
Value: XML Representation: NULL (unknown value) <field name="column_name" xsi:nil="true" /> '' (empty string) <field name="column_name"></field> 'NULL' (string value) <field name="column_name">NULL</field> The output from the mysql client when run ... The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/non-typed-operators.html
->> Return value from JSON column after evaluating path and unquoting the result; equivalent to JSON_UNQUOTE(JSON_EXTRACT()). / Division operator := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in an ...
