Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-schema-validation.html
This is done by specifying a JSON Schema during Collection creation or modification; schema validation is then performed by the server at a document creation or update, and an error is returned if the document does not validate against the assigned ... When working with MySQL Server 8.0.19 and later: Schema validation can be configured for a Collection, so that documents in the Collection are validated against a schema before they can be inserted or ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-troubleshooting.html
Consider the following series of statements for example: conn.createStatement().execute( "UPDATE checking_account SET balance = balance - 1000.00 WHERE customer='Smith'"); conn.createStatement().execute( "UPDATE savings_account SET balance = balance ... This section explains the symptoms and resolutions for the most commonly encountered issues with applications using MySQL ...
MySQL Cluster Manager 8.4 User Manual :: 3.3.2 Installing MySQL Cluster Manager on Windows Platforms
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-install-agent-windows.html
As the installer begins to copy files and perform other tasks affecting the system, you may see a warning dialog from Windows User Access Control. As mentioned elsewhere (see, for example, Section 4.4.1, “Creating a MySQL NDB Cluster with MySQL ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-terminology.html
The MySQL Cluster Manager client is a software application that allows a user to connect to MySQL Cluster Manager and perform administrative tasks, such as (but not limited to): creating, starting, and stopping clusters; obtaining cluster and ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-17.html
See Indexing Array Fields in the X DevAPI User Guide for details. (Bug #29446100, Bug #94533) ResultSetImpl.getDouble() was very inefficient because it called FloatingPointBoundsEnforcer.createFromBigDecimal, which needlessly recreated BigDecimal ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-9.html
Components that support DDLS for tables, including the createTable(), dropTable(), and modifyTable() methods. (WL #11210) X DevAPI: The createIndex() method for the Collection interface now has a new syntax. Users can still set useInformationSchema ... Version 8.0.9 Release Candidate is the first release candidate of the 8.0 branch of MySQL Connector/J, providing an insight into upcoming ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-9-2-0.html
(Bug #116113, Bug #37063728, Bug #63992, Bug #14598872) It might take a long time to create a connection to a server with Connector/J 8.4.0 or later. (Bug #96786, Bug #30280035) When updateRow() was called after some updates have been performed on a ... Version 9.2.0 is a new GA release of MySQL ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-9-6-0.html
Note These release notes were created with the assistance of MySQL HeatWave GenAI. (Bug #118002, Bug #37843004) The login timeout set with DriverManager.setLoginTimeout() incorrectly affected JdbcConnection.changeUser() calls. The handling of login ...MySQL Connector/J 9.6.0 supersedes 9.5 and is recommended for use on production ...
https://dev.mysql.com/doc/refman/9.7/en/alter-json-duality-view.html
ALTER [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}] [DEFINER = user] [SQL SECURITY { DEFINER | INVOKER }] JSON DUALITY VIEW view_name AS json_duality_select_statement [WITH [CASCADED | LOCAL] CHECK OPTON] json_duality_select_statement: SELECT ...
https://dev.mysql.com/doc/refman/9.7/en/ansi-diff-select-into-table.html
For example: INSERT INTO tbl_temp2 (fld_id) SELECT tbl_temp1.fld_order_id FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100; Alternatively, you can use SELECT ... The same syntax can also be used inside stored routines using cursors and local ...