Search Results
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-document-ids.html
// using a book's unique ISBN as the object ID myColl.add( { _id: "978-1449374020", title: "MySQL Cookbook: Solutions for Database Developers and Administrators" }).execute(); Use find() to fetch the newly inserted book from the collection by its ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/main-queries-reference.html
It is not possible to use INSERT, UPDATE, DELETE, and so on. The main queries enable you to retrieve data from the monitored server. When defining queries, the following restrictions apply: The query must be defined within a <![CDATA[]]> container.
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-qanal-using-ui.html
DML Statements: filters on statements of type SELECT, INSERT, UPDATE, DELETE, REPLACE, CALL, LOAD, DO, and HANDLER. To open the Query Analyzer, select Queries from the navigation menu. Figure 32.1 Default Query Analyzer View Table 32.2 Controls of ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-replication-dashboard-ui-ref.html
The following graphs are available: Database Activity - All MySQL Instances: displays the total number of SELECT, INSERT, UPDATE, REPLACE, DELETE, and CALL statements performed on all members of the selected group. Important The Max Replication ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-ui-configuration-views-ref.html
DML Statements: filters on statements of type SELECT, INSERT, UPDATE, DELETE, REPLACE, CALL, LOAD, DO, and HANDLER. Configuration views are similar to System and User Filters, see Section 14.3.5, “System and User-defined Filters”, but are ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mysql-process-discovery-advisor-ref.html
Admin User The root user of the instance, or a user that has the SUPER, CREATE, and INSERT privileges on the schema in which the inventory table is created. The MySQL Process Discovery Advisor enables you to find and, optionally, establish a ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/collection-validation.html
This enables you to require that documents have a certain structure before they can be inserted or updated in a collection. Collections can be configured to verify documents against a JSON schema. Schema validation is performed by the server, which ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/crud-ebnf-table-crud-functions.html
TableSelectFunction Table.select() and collection.find() use different methods for sorting results. Table.select() follows the SQL language naming and calls the sort method orderBy(). Use the method sort() to sort the results returned by ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/crud-operations-overview.html
Operation Document Relational Create Section 4.3.1, “Collection.add()” Table.insert() Read Section 4.3.2, “Collection.find()” Table.select() Update Section 4.3.3, “Collection.modify()” Table.update() Delete Section 4.3.4, ... CRUD ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/result-set-classes.html
The type of result returned depends on the operation that was executed. The different types of results are outlined in the following table. SqlResult session.sql().execute() Number of rows affected by the operation, auto generated document IDs, last ...