Search Results
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-tracing-mysql-custom-listeners.html
To build custom listeners that work with the MySQL Connector/NET Trace Source, it is necessary to understand the key methods used, and the event data formats used. The main method involved in passing trace messages is the TraceSource.TraceEvent ...
https://dev.mysql.com/doc/connector-net/en/connector-net-using-character-sets.html
To insert 4-byte UTF8 strings into blob columns, use the .NET Encoding.GetBytes function to convert your string to a series of bytes. Treating Binary Blobs As UTF8 Before the introduction of 4-byte UTF-8 character set, MySQL did not support 4-byte ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-architecture.html
The database is used as the source of the data (during queries) and the destination for data (during inserts and updates). The Connector/ODBC architecture is based on five components, as shown in the following diagram: Figure 3.1 Connector/ODBC ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-overview.html
For Delete / Update / Insert the results might include the number of rows affected. Interacting with a MySQL server from an applications using the Connector/ODBC typically involves the following operations: Configure the Connector/ODBC DSN. This ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-crystalreports.html
Open Crystal Reports and create a new project, or an open an existing reporting project into which you want to insert data from your MySQL data source. Crystal Reports can use an ODBC DSN to connect to a database from which you to extract data and ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-microsoft-excel.html
If you have problems importing data into Microsoft Excel, particularly numeric, date, and time values, this is probably because of a bug in Excel, where the column type of the source data is used to determine the data type when that data is ...The ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-cext-query.html
ccnx.query('DROP TABLE IF EXISTS t') ccnx.query('CREATE TABLE t (i INT NOT NULL AUTO_INCREMENT PRIMARY KEY)') ccnx.query('INSERT INTO t (i) VALUES (NULL),(NULL),(NULL)') ccnx.query('SELECT LAST_INSERT_ID()') row = ccnx.fetch_row() ...raw_as_string ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-commit.html
>>> cursor.execute("INSERT INTO employees (first_name) VALUES (%s), (%s)", ('Jane', 'Mary')) >>> cnx.commit() To roll back instead and discard modifications, see the rollback() method. This method sends a COMMIT statement to the MySQL server, ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-rollback.html
>>> cursor.execute("INSERT INTO employees (first_name) VALUES (%s), (%s)", ('Jane', 'Mary')) >>> cnx.rollback() To commit modifications, see the commit() method. This method sends a ROLLBACK statement to the MySQL server, undoing all data changes ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-rowcount.html
Syntax: count = cursor.rowcount This read-only property returns the number of rows returned for SELECT statements, or the number of rows affected by DML statements such as INSERT or UPDATE. For nonbuffered cursors, the row count cannot be known ...