Search Results
https://dev.mysql.com/doc/connectors/en/connector-j-schema-validation.html
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 updated. Attempting to insert or modify a ...
https://dev.mysql.com/doc/connectors/en/connector-net-entityframework60.html
Code First Features Following are new Code First features supported by Connector/NET: Code First Mapping to Insert/Update/Delete Stored Procedures supported: modelBuilder.Entity<EntityType>().MapToStoredProcedures(); Idempotent migrations scripts ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-prepared.html
Prepared statements can provide significant performance improvements on queries that are executed more than one time. Prepared execution is faster than direct execution for statements executed more than once, primarily because the query is parsed ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-data-adapter.html
From this SELECT statement the Command Builder can work out the corresponding INSERT, UPDATE and DELETE statements that would be required to update the database. Instantiating a MySqlCommandBuilder Object Once the MySqlDataAdapter has been created, ... Previously, when using MySqlDataReader, the connection to the database was continually maintained unless explicitly ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-reference-api.html
(Useful for long data values.) Table 5.10 ODBC API Calls for Retrieving Results and Information about Results Function Name Connector/ODBC Supports? Standard Purpose SQLRowCount Yes ISO 92 Returns the number of rows affected by an insert, update, or ...For the complete ODBC API reference, please refer to the ODBC Programmer's Reference at ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-cmd-query-iter.html
The following example shows how to iterate through the results after sending multiple statements: statement = 'SELECT 1; INSERT INTO t1 VALUES (); SELECT 2' for result in cnx.cmd_query_iter(statement): if 'columns' in result: columns = ... Syntax: ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-execute.html
This example inserts information about a new employee, then selects the data for that person. Syntax: cursor.execute(operation, params=None) iterator = cursor.execute(operation, params=None) # Allowed before 9.2.0 iterator = ...
https://dev.mysql.com/doc/connectors/en/connector-python-connectargs.html
Call the commit() method of the MySQLConnection instance within your application after doing a set of related insert, update, and delete operations. A connection with the MySQL server can be established using either the mysql.connector.connect() ...
https://dev.mysql.com/doc/connector-net/en/connector-net-entityframework60.html
Code First Features Following are new Code First features supported by Connector/NET: Code First Mapping to Insert/Update/Delete Stored Procedures supported: modelBuilder.Entity<EntityType>().MapToStoredProcedures(); Idempotent migrations scripts ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-prepared.html
Prepared statements can provide significant performance improvements on queries that are executed more than one time. Prepared execution is faster than direct execution for statements executed more than once, primarily because the query is parsed ...