Search Results
https://dev.mysql.com/doc/workbench/en/wb-preferences-sql-editor.html
If this option is turned on, data truncation may result: Binary byte string values may contain null bytes as part of their valid data, whereas for nonbinary character strings, a null byte terminates the string. This section provides configuration ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-security.html
paranoid Take measures to prevent exposure sensitive information in error messages and clear data structures holding sensitive data when possible? Default Value false Since Version 3.0.1 serverRSAPublicKeyFile File path to the server RSA public key ...
https://dev.mysql.com/doc/connectors/en/connector-j-reference-implementation-notes.html
If this value is set to NULL, the driver will revert to using a FileInputStream or URLInputStream as required. This method returns NULL if no such stream has been set using setLocalInfileInputStream(). MySQL Connector/J, as a rigorous ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-tomcat.html
The following instructions are based on the instructions for Tomcat-5.x, available at http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html which is current at the time this document was written. First, install the .jar file ...
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-datetime-invalid.html
The MySqlDateTime class supports NULL dates, while the .NET DateTime class does not. This can cause errors when trying to convert a MySQLDateTime to a DateTime if you do not check for NULL first. Although it is strongly recommended that you avoid ...
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-odbc-configuration-connection-parameters.html
NO_CATALOG Disable catalog support 32768 Forces results from the catalog functions, such as SQLTables, to always return NULL and the driver to report that catalogs are not supported. AUTO_IS_NULL Enable SQL_AUTO_IS_NULL 8388608 When AUTO_IS_NULL is ...On Unix and macOS, use the parameter name and value as the keyword/value pair in the DSN ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-programming-vb.html
This section contains simple examples of the use of Connector/ODBC with ADO, DAO and RDO. 5.6.7.1.1 ADO: rs.addNew, rs.delete, and rs.update The following ADO (ActiveX Data Objects) example creates a table my_ado and demonstrates the use of ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-errors-dataerror.html
Examples are a column set to NULL that cannot be NULL, out-of-range values for a column, division by zero, column count does not match value count, and so on. This exception is raised when there were problems with the data.