Search Results
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-storage-layout.html
Use the VARCHAR data type instead of CHAR to store variable-length strings or for columns with many NULL values. A CHAR(N) column always takes N characters to store data, even if the string is shorter or its value is NULL. Once your data reaches a ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-bind-param.html
name: The address of an array of character pointers, each pointing to a null-terminated string defining an attribute name. bool mysql_bind_param(MYSQL *mysql, unsigned n_params, MYSQL_BIND *bind, const char **name) Description mysql_bind_param(), ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-sqlstate.html
const char * mysql_sqlstate(MYSQL *mysql) Description Returns a null-terminated string containing the SQLSTATE error code for the most recently executed SQL statement. Return Values A null-terminated character string containing the SQLSTATE error ...'00000' means “no error.” The values are specified by ANSI SQL and ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-sqlstate.html
const char * mysql_stmt_sqlstate(MYSQL_STMT *stmt) Description For the statement specified by stmt, mysql_stmt_sqlstate() returns a null-terminated string containing the SQLSTATE error code for the most recently invoked prepared statement API ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-9-4-0.html
(Bug #118201, Bug #37971552) When using Connector/J 9.3.0 0 with useInformationSchema=true, calling DatabaseMetaData.getTables with the arguments catalog, schemaPattern and tableNamePattern set to null caused an SQL syntax exception. (Bug #77658, ...
https://dev.mysql.com/doc/internals/en/connection-phase-packets.html
Protocol::Handshake Initial Handshake Packet When the client connects to the server the server sends a handshake packet to the client. Depending on the server version and configuration options different variants of the initial packet are sent. To ...
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-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-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/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.