Search Results
https://dev.mysql.com/doc/connectors/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 ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlcursorbuffereddict.html
A MySQLCursorBufferedDict cursor is like a MySQLCursorDict cursor, but is buffered: After executing a query, it fetches the entire result set from the server and buffers the rows. For information about the implications of buffering, see Section ...
https://dev.mysql.com/doc/connectors/en/connector-python-example-cursor-transaction.html
Inserting or updating data is also done using the handler structure known as a cursor. When you use a transactional storage engine such as InnoDB (the default in MySQL 5.5 and higher), you must commit the data after a sequence of INSERT, DELETE, ...
https://dev.mysql.com/doc/connector-net/en/connector-net-8-0-connection-options.html
CharacterSet , Character Set , CharSet Specifies the character set that should be used to encode all queries sent to the server. This chapter describes the full set of MySQL Connector/NET 8.0 connection options. The protocol you use to make 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-programming-blob-reading.html
After a file is loaded into the file table, we can use the MySqlDataReader class to retrieve it. The GetBytes method of the MySqlDataReader is used to load the BLOB into a byte array, which is then written to disk using a FileStream object. The ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-blob-writing.html
To write a file to a database, we need to convert the file to a byte array, then use the byte array as a parameter to an INSERT query. After assigning the byte array as a parameter of the MySqlCommand object, the ExecuteNonQuery method is called ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-crystal-source.html
When creating a report in Crystal Reports there are two options for accessing the MySQL data while designing your report. The first option is to use Connector/ODBC as an ADO data source when designing your report. You will be able to browse your ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-datetime-null.html
As such, when assigning values from a query to a DateTime variable, you must first check whether the value is in fact NULL.
https://dev.mysql.com/doc/connector-net/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 ...