Search Results
https://dev.mysql.com/doc/connectors/en/connector-net-programming.html
MySqlCommandBuilder: Automatically generates single-table commands used to reconcile changes made to a DataSet with the associated MySQL database. MySQL Connector/NET comprises several classes that are used to connect to the database, execute ...
https://dev.mysql.com/doc/connectors/en/connector-net-ref-entityframework.html
Classes Class Description BackoffAlgorithm Represents the base class for backoff algorithms. BackoffAlgorithmErr1040 Backoff algorithm customized for the MySQL error code 1040 - Too many connections. BackoffAlgorithmErr1205 Backoff algorithm ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-entity-framework-databinding-linq-entities.html
The following figure shows Belgium selected from the list box and a table with three columns: Name, Population, and CountryCode. In this tutorial you create an ASP.NET web page that binds LINQ queries to entities using the Entity Framework mapping ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-tools-with-access.html
The MySQL database can be used as an import source, an export source, or as a linked table for direct use within an Access application, so you can use Access as the front-end interface to a MySQL database. You can use a MySQL database with ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-errors-integrityerror.html
The following example shows a duplicate key error raised as IntegrityError: cursor.execute("CREATE TABLE t1 (id int, PRIMARY KEY (id))") try: cursor.execute("INSERT INTO t1 (id) VALUES (1)") cursor.execute("INSERT INTO t1 (id) VALUES (1)") except ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-errors-programmingerror.html
This exception is raised on programming errors, for example when you have a syntax error in your SQL or a table was not found. The following example shows how to handle syntax errors: try: cursor.execute("CREATE DESK t1 (id int, PRIMARY KEY (id))") ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-cmd-process-info.html
Instead, use the SHOW PROCESSLIST statement or query the tables found in the database INFORMATION_SCHEMA.
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-cmd-refresh.html
This method flushes tables or caches, or resets replication server information. The options argument should be a bitmask value constructed using constants from the constants.RefreshOption class. Example: >>> from mysql.connector import RefreshOption ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-cmd-statistics.html
Returns a dictionary containing information about the MySQL server including uptime in seconds and the number of running threads, questions, reloads, and open tables.
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-commit.html
Since by default Connector/Python does not autocommit, it is important to call this method after every transaction that modifies data for tables that use transactional storage engines. This method sends a COMMIT statement to the MySQL server, ...