Search Results
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, ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-set-client-flags.html
For example, to unset LONG_FLAG and set the FOUND_ROWS flags: >>> from mysql.connector.constants import ClientFlag >>> cnx.set_client_flags([ClientFlag.FOUND_ROWS, -ClientFlag.LONG_FLAG]) >>> cnx.reconnect() Note Client flags are only set or used ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-sql-mode.html
>>> cnx.sql_mode = 'TRADITIONAL,NO_ENGINE_SUBSTITUTION' >>> cnx.sql_mode.split(',') [u'STRICT_TRANS_TABLES', u'STRICT_ALL_TABLES', u'NO_ZERO_IN_DATE', u'NO_ZERO_DATE', u'ERROR_FOR_DIVISION_BY_ZERO', u'TRADITIONAL', u'NO_AUTO_CREATE_USER', ... This ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor-with-rows.html
Syntax: boolean = cursor.with_rows This read-only property returns True or False to indicate whether the most recently executed operation could have produced rows. The with_rows property is useful when it is necessary to determine whether a ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursor.html
To create a cursor, use the cursor() method of a connection object: import mysql.connector cnx = mysql.connector.connect(database='world') cursor = cnx.cursor() Several related classes inherit from MySQLCursor. The MySQLCursor class instantiates ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursorbuffered.html
Example: import mysql.connector cnx = mysql.connector.connect() # Only this particular cursor will buffer results cursor = cnx.cursor(buffered=True) # All cursors created from cnx2 will be buffered by default cnx2 = ...After executing a query, a ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursorraw.html
Example: import mysql.connector cnx = mysql.connector.connect() # Only this particular cursor will be raw cursor = cnx.cursor(raw=True) # All cursors created from cnx2 will be raw by default cnx2 = mysql.connector.connect(raw=True) . A ...
https://dev.mysql.com/doc/connector-net/en/connector-net-entityframework60.html
MySQL Connector/NET integrates support for Entity Framework 6 (EF6), which now includes support for cross-platform application deployment with the EF 6.4 version. This chapter describes how to configure and use the EF6 features that are implemented ...
https://dev.mysql.com/doc/connector-net/en/connector-net-installation-binary-nuget.html
Important For projects that require Connector/NET assemblies to be stored in the GAC or integration with Entity Framework Designer (Visual Studio), use the standalone MSI to install Connector/NET, rather than installing the NuGet packages. MySQL ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-binary-issues.html
With the availability of BINARY and VARBINARY data types, it is important to respect the metadata returned by the server. There are certain situations where MySQL will return incorrect metadata about one or more columns. More specifically, the ...