Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/dynamic-sql.html
A quoting function exists to escape SQL names and identifiers. Session.quoteName() escapes the identifier given in accordance to the settings of the current connection. Note The quoting function must not be used to escape values. Use the value ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/setting-the-current-schema.html
var mysqlx = require('mysqlx'); // Direct connect with no client-side default schema specified var mySession = mysqlx.getSession('user:password@localhost'); mySession.setCurrentSchema("test"); Notice that setCurrentSchema() does not change the ... A ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/shell-automatic-code-execution-results.html
mysql-js> db.countryInfo.find().limit(1) [ { "GNP": 828, "IndepYear": null, "Name": "Aruba", "_id": "ABW", "demographics": { "LifeExpectancy": 78.4000015258789, "Population": 103000 }, "geography": { "Continent": "North America", "Region": ... When ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-data-sets.html
When the last data item has been read and fetchOne() is called again, a NULL value is returned. Operations that fetch data items return a cursor that can be used to consume those data items from the result set. Data items can be read from the ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-sql-result-sets.html
The data set can be empty if, for example, fetchOne() returns NULL or fetchAll() returns an empty list. When you execute an SQL operation on a Session using the sql() method, an SqlResult is returned. Iterating over an SqlResult is identical to ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-remove.html
All documents in the collection are removed if any expression that evaluates to true without matching any document (for example, “true” or “_id IS NOT NULL”) is passed as the search condition string. The Collection.remove() function is for ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-single-document-operations.html
This operation returns the document, or NULL if no match is found. The CRUD commands described at Section 4.3, “Collection CRUD Function Overview” all act on a group of documents in a collection that match a filter. X DevAPI also provides the ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/connection-attributes-xdevapi.html
When a value is missing from a key-value pair, a null value is set for the attribute The following is a generic example of a connection string that configures the connection attributes: ... Connection attributes are key-value pairs that application ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/dynamic-sql.html
A quoting function exists to escape SQL names and identifiers. Session.quoteName() escapes the identifier given in accordance to the settings of the current connection. Note The quoting function must not be used to escape values. Use the value ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/setting-the-current-schema.html
from mysqlsh import mysqlx # Direct connect with no client-side default schema specified mySession = mysqlx.get_session('user:password@localhost') mySession.set_current_schema("test") Notice that setCurrentSchema() does not change the session's ...