Search Results
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-restricting.html
This can be done on either the client or the server side. For information on using the traditional SQL mode, see Server SQL Modes. The best solution to the date problem is to restrict users from entering invalid dates. Restricting invalid dates on ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-prepared.html
Another advantage of prepared statements is that, with server-side prepared statements enabled, it uses a binary protocol that makes data transfer between client and server more efficient. Prepared statements can provide significant performance ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-telemetry.html
If the server does not support query attributes or has them disabled, then Connector/NET skips the entire context propagation flow. OpenTelementry (OTel) standardizes instrumentation, generation, collecting and exporting telemetry data to be ...
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-odbc/en/connector-odbc-examples-programming-vb-ado.html
The following ADO (ActiveX Data Objects) example creates a table my_ado and demonstrates the use of rs.addNew, rs.delete, and rs.update. rs.Open "SELECT * FROM my_ado" rs!Name = "update" rs!txt = "updated-second-time" rs.Update rs.Close 'rs delete ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndbinfo-select-all.html
ndbinfo_select_all is a client program that selects all rows and columns from one or more tables in the ndbinfo database Not all ndbinfo tables available in the mysql client can be read by this program (see later in this section). In addition, ...
https://dev.mysql.com/doc/refman/8.4/en/common-errors.html
Although the problems show up when you try to run client programs, the solutions to many of the problems involves changing the configuration of the MySQL server. This section lists some errors that users frequently encounter when running MySQL ...