Search Results
https://dev.mysql.com/doc/connector-net/en/connector-net-faq.html
To stop that, once all your commands have been added you need to disconnect the CommandBuilder from the DataAdapter: cb.DataAdapter = null; The last requirement is to make sure the id that is returned by last_insert_id() has the correct name.
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-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/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-odbc/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/connector-python/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.
https://dev.mysql.com/doc/internals/en/better-protocols-example.html
SET @aux = 1; SELECT @aux AS "content of @aux is"; content of @aux is 1 SELECT @aux AS "content of @aux is"; content of @aux is NULL . The output becomes less clear because there is no indication that the connection has been changed.
https://dev.mysql.com/doc/internals/en/defining-filename-extensions.html
Extensions are expected in the form of a null-terminated string array. Storage engines are required to provide the MySQL server with a list of extensions used by the storage engine with regard to a given table, its data and indexes.
https://dev.mysql.com/doc/internals/en/negative-tests.html
Column with numeric data type: NULL, 0 Minimum - 1, Minimum, Minimum + 1 Maximum - 1, Maximum, Maximum + 1 Negative values if data type is unsigned Garbage like 'abc', '1a', 'a1' Column with string data type: Null, <empty string>, "exotic" ... A ...
https://dev.mysql.com/doc/internals/en/optimizer-constants-constant-tables.html
unique_not_null_column INT NOT NULL UNIQUE then this expression FROM Table1 ... Here's an example: SELECT Table1.unique_not_null_column, Table2.any_column FROM Table1, Table2 WHERE Table1.unique_not_null_column = Table2.any_column AND ... A MySQL ...