PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-documents-modify.html
mysql-js> db.countryinfo.modify("Name = 'France'").arrayInsert("$.Airports[0]", "CDG") To delete an element from the array, you must pass to the arrayDelete() method the index of the element to be deleted. You can use the modify() method to update ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-shell.html
To be able to use the instance as a Document Store, the server instance must have X Plugin installed and you should connect to the server using X Protocol. For instructions on setting up the world_x schema, see Section 22.3.2, “Download and Import ...The following section is a high level overview, see the MySQL Shell documentation for more ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-collections-operations.html
In MySQL Shell, you can create new collections, get a list of the existing collections in a schema, and remove an existing collection from a schema. Collection names are case-sensitive and each collection name must be unique. The following example ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-documents-find.html
You can use the find() method to query for and return documents from a collection in a schema. MySQL Shell provides additional methods to use with the find() method to filter and sort the returned documents. MySQL provides the following operators ...Avoid introducing values in queries using string concatenation, which can produce invalid input and, in some cases, can cause security ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-documents-modify.html
mysql-py> db.countryinfo.modify("Name = 'France'").array_insert("$.Airports[0]", "CDG") To delete an element from the array, you must pass to the array_delete() method the index of the element to be deleted. You can use the modify() method to ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-python-shell.html
To be able to use the instance as a Document Store, the server instance must have X Plugin installed and you should connect to the server using X Protocol. For instructions on setting up the world_x schema, see Section 22.4.2, “Download and Import ...The following section is a high level overview, see the MySQL Shell documentation for more ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-stored-programs.html
The other options are disabled by default and must be specified explicitly to dump the corresponding objects. To disable any of these options explicitly, use its skip form: --skip-events, --skip-routines, or --skip-triggers.
https://dev.mysql.com/doc/refman/8.0/en/outer-join-simplification.html
Table expressions in the FROM clause of a query are simplified in many cases. At the parser stage, queries with right outer join operations are converted to equivalent queries containing only left join operations. When the optimizer evaluates plans ...
https://dev.mysql.com/doc/refman/8.0/en/pattern-matching.html
(This differs from a LIKE pattern match, which succeeds only if the pattern matches the entire value.) To anchor a pattern so that it must match the beginning or end of the value being tested, use ^ at the beginning or $ at the end of the pattern.
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-applier-configuration-table.html
DESIRED_DELAY The number of seconds that the replica must lag the source. This table shows the configuration parameters that affect transactions applied by the replica. Parameters stored in the table can be changed at runtime with the CHANGE ...