Search Results
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 ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/custom-xml-reference.html
For example, the precondition query can be used to check the version of the MySQL server. For more information, see Section 31.2.2.2, “Main Queries” attributes Enables you to label the types of data returned by the query. It is also possible to ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/formatting-queries-reference.html
It is possible to format the query result with wiki markup. This enables you to display information from the query directly in the event generated by the advisor. This example lists the user name and host for all accounts without a defined password. See Section 31.1.7, “Wiki Format” for more information on the supported wiki ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-acl-core-assets-permissions.html
Similarly, if you set Server Group to Administer, MySQL Instances is also set to Administer. It is not possible to set MySQL Instances or any of the NDB Cluster permissions to None if Server Group is set to Read-Only or higher. The Core Monitored ...