Search Results
https://dev.mysql.com/doc/connectors/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/connectors/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/connectors/en/connector-net-programming-prepared.html
Prepared statements can provide significant performance improvements on queries that are executed more than one time. Prepared execution is faster than direct execution for statements executed more than once, primarily because the query is parsed ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-tablecaching.html
Configuration To enable table caching, add 'table cache = true' to the connection string. Optionally, specify the 'Default Table Cache Age' connection string option, which represents the number of seconds a table is cached before the cached data is ... Table caching is a feature that can be used to cache slow-changing datasets on the client ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-sql-mode.html
To unset all modes, pass an empty string or an empty sequence. >>> 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', ... This property ...
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-prepared.html
Prepared statements can provide significant performance improvements on queries that are executed more than one time. Prepared execution is faster than direct execution for statements executed more than once, primarily because the query is parsed ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-tablecaching.html
Configuration To enable table caching, add 'table cache = true' to the connection string. Optionally, specify the 'Default Table Cache Age' connection string option, which represents the number of seconds a table is cached before the cached data is ... Table caching is a feature that can be used to cache slow-changing datasets on the client ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-programming-vb-dao.html
Set rs = conn.OpenRecordset("my_dao") rs.Edit rs!Name = "updated-string" rs.Update rs.Close 'fetch the table back... The following DAO (Data Access Objects) example creates a table my_dao and demonstrates the use of rs.addNew, rs.update, and result ...