Search Results
https://dev.mysql.com/doc/relnotes/connector-python/en/news-8-0-21.html
(WL #12501) Document Store: Connector/Python now provides JSON schema validation for a collection to enforce a certain structure that documents must adhere to before they are permitted to be inserted or updated. Functionality Added or Changed Bugs ...
https://dev.mysql.com/doc/relnotes/connector-python/en/news-8-0-29.html
(Bug #81519, Bug #23324748) Attempts to insert Python ByteArray data into binary table columns failed when using the c-extension implementation of Connector/Python. Functionality Added or Changed Bugs Fixed Functionality Added or Changed When a ...
https://dev.mysql.com/doc/x-devapi-userguide/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/en/creating-a-collection.html
It returns a Collection object that can be used right away to, for example, insert documents into the database. In order to create a new collection call the createCollection() function from a Schema object. Optionally, for Connectors, the field ...
https://dev.mysql.com/doc/x-devapi-userguide/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/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/en/index.html
For help with using MySQL, please visit the MySQL Forums, where you can discuss your issues with other MySQL users.
https://dev.mysql.com/doc/x-devapi-userguide/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 ...
https://dev.mysql.com/doc/x-devapi-userguide/en/value-expression-strings.html
This is necessary for both modify() and update(), as well as computing values in documents at insertion time. Value expression strings are used to compute a value which can then be assigned to a given field or column. An example use of a value ...
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 ...