Search Results
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-data-structures.html
bool *is_null This member points to a bool variable that is true if a value is NULL, false if it is not NULL. For input, set *is_null to true to indicate that you are passing a NULL value as a statement parameter. is_null is a pointer to a boolean ... Prepared statements use several data structures: To obtain a statement handler, pass a MYSQL connection handler to mysql_stmt_init(), which returns a pointer to a MYSQL_STMT data ...
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/refman/8.4/en/load-data-local-security.html
Interpretation of the MYSQL_OPT_LOAD_DATA_LOCAL_DIR value is as follows: If the value is the null pointer (the default), it names no directory, with the result that no files are permitted for LOCAL data loading. mysql uses the option value to set ...
https://dev.mysql.com/doc/internals/en/decoding-specification.html
Alignment: x bits alignment to the next byte border Code Trees. For every record: 1-5 bytes length of the compressed record in bytes 1.
https://dev.mysql.com/doc/refman/8.4/en/password-management.html
MySQL supports these password-management capabilities: Password expiration, to require passwords to be changed periodically. Password reuse restrictions, to prevent old passwords from being chosen again. Password verification, to require that ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-memory.html
To replicate this effect to replicas, the first time that the source uses a given MEMORY table after startup, it logs an event that notifies replicas that the table must be emptied by writing a DELETE or TRUNCATE TABLE statement for that table to ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-innodb-cluster-working-with-clone.html
An InnoDB Cluster that uses MySQL Clone provides the following additional behavior. dba.createCluster() and MySQL Clone By default, when a new cluster is created on an instance where the MySQL Clone plugin is available, it is automatically ...
https://dev.mysql.com/doc/refman/8.4/en/constant-folding-optimization.html
Consider the table created by the following statement: CREATE TABLE t (c TINYINT UNSIGNED NOT NULL); The WHERE condition in the query SELECT * FROM t WHERE c < 256 contains the integral constant 256 which is out of range for a TINYINT UNSIGNED ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-copy-mysql-configuration.html
For any variables of the string data type, an empty value field means an empty string, except for nullable variables such as innodb_ft_server_stopword_table , for which an empty value field is taken as MYSQL NULL (i.e., a null value). Copying a ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-create-mysql-configuration.html
For any variables of the string data type, an empty value field means an empty string, except for nullable variables such as innodb_ft_server_stopword_table , for which an empty value field is taken as MYSQL NULL (i.e., a null value). Creating a ...