Search Results
https://dev.mysql.com/doc/x-devapi-userguide/en/collection-remove.html
It assumes some documents have been added to the collection as illustrated by the code example in Section 4.3.1, “Collection.add()”: MySQL Shell JavaScript Code // Use the collection 'my_collection' var myColl = ... The Collection.remove() ...
https://dev.mysql.com/doc/x-devapi-userguide/en/collections-as-relational-tables.html
Applications that seek to store standard SQL columns with Documents can cast a collection to a table. In this case a collection can be fetched as a Table object with the Schema.getCollectionAsTable() function. From that moment on it is treated as a ...
https://dev.mysql.com/doc/x-devapi-userguide/en/connecting-to-one-of-multiple-hosts.html
You can provide multiple MySQL Router or server endpoints (as host and an optional port, or Unix sockets) when creating a session. Note The user and password you supply in the URI-like string apply to all of the possible endpoints and therefore the ...You specify a URI-like string which contains multiple hosts, ports, and optional ...
https://dev.mysql.com/doc/x-devapi-userguide/en/creating-a-collection.html
In order to create a new collection call the createCollection() function from a Schema object. It returns a Collection object that can be used right away to, for example, insert documents into the database. Optionally, for Connectors, the field ...
https://dev.mysql.com/doc/x-devapi-userguide/en/dynamic-sql.html
C++ Code #include <mysqlx/xdevapi.h> // Note: The following features are not yet implemented by // Connector/C++: // - DataSoure configuration files, // - quoteName() method. A quoting function exists to escape SQL names and identifiers.
https://dev.mysql.com/doc/x-devapi-userguide/en/expression-strings.html
The disadvantage is that they need to be parsed before they can be transfered to the MySQL server. All implementations can use the syntax illustrated here, which is shown as MySQL Shell JavaScript code. Defining string expressions is ...
https://dev.mysql.com/doc/x-devapi-userguide/en/method-chaining.html
MySQL Shell JavaScript Code // New method chaining used for executing an SQL SELECT statement // Recommended way for executing queries var employees = db.getTable('employee'); var res = employees.select(['name', 'age']). X DevAPI supports a number ...
https://dev.mysql.com/doc/x-devapi-userguide/en/setting-the-current-schema.html
*/ C# Code // Direct connect with no client-side default schema specified var mySession = MySQLX.GetSession("server=localhost;port=33060;user=user;password=password;"); mySession.SetCurrentSchema("test"); Python Code # Connector/Python from mysqlsh ... A default schema for a session can be specified using the schema attribute in the URI-like connection string or key-value pairs when opening a connection ...
https://dev.mysql.com/doc/x-devapi-userguide/en/sql-crud-functions.html
MySQL Shell JavaScript Code // Accessing an existing table var myTable = db.getTable('my_table'); // Insert a row of data. execute(); MySQL Shell Python Code # Accessing an existing table myTable = db.get_table('my_table') # Insert a row of data.
https://dev.mysql.com/doc/relnotes/mysql-monitor/8.0/en/preface.html
This document lists the changes to the MySQL Enterprise Monitor 8.0 product, beginning with the most recent release. Trademark Notice Oracle, Java, MySQL, and NetSuite are registered trademarks of Oracle and/or its affiliates. License Restrictions ...