Search Results
https://dev.mysql.com/doc/refman/8.4/en/window-functions-usage.html
NULL values sort first for ascending sorts, last for descending sorts. However, whereas an aggregate operation groups query rows into a single result row, a window function produces a result for each query row: The row for which function evaluation ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-checking-installation.html
| mysqlx | ACTIVE | DAEMON | NULL | GPL | ... X Plugin is enabled by default in MySQL 8, therefore installing or upgrading to MySQL 8 makes the plugin available. You can verify X Plugin is installed on an instance of MySQL server by using the SHOW ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-3.html
InnoDB: InnoDB did not allow updating a REDUNDANT table column that was altered with NULL as the default value using the INSTANT algorithm. (Bug #36259487) InnoDB: A schema mismatch was possible when a table was imported with a different sql_mode ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-commands-other.html
Use the --error-code option to supply the exit code for which you want to receive the associated exit message: $ mysqlbackup print-message --error-code=4 2> /dev/null One of the required files not found For a list of mysqlbackup exit codes and ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.restore.html
To restore a MySQL instance from a backup to a database server: Shut down the database server. Also delete all files inside the directories specified by the --innodb_data_home_dir, --innodb_log_group_home_dir, and --innodb_undo_directory options ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/client-error-reference.html
Client error messages originate from within the MySQL client library. Here is an example client error message, as displayed by the mysql client: $> mysql -h no-such-host ERROR 2005 (HY000): Unknown MySQL server host 'no-such-host' (0) Each client ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-binary-log-interface-usage.html
The following simple example program demonstrates the binary log C API functions. Program notes: mysql is assumed to be a valid connection handler. The initial SET statement sets the @source_binlog_checksum user-defined variable that the server ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-multiple-queries.html
By default, mysql_real_query() and mysql_query() interpret their statement string argument as a single statement to be executed, and you process the result according to whether the statement produces a result set (a set of rows, as for SELECT) or ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-optional-metadata.html
For metadata-optional connections, the mysql_fetch_field(), mysql_fetch_field_direct(), and mysql_fetch_fields() functions return NULL when resultset_metadata is set to NONE. When a client executes a statement that produces a result set, MySQL ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-date-handling.html
mysql_stmt_bind_named_param(stmt, bind, 3, NULL); /* supply the data to be sent in the ts structure */ ts.year= 2002; ts.month= 02; ts.day= 03; ts.hour= 10; ts.minute= 45; ts.second= 20; mysql_stmt_execute(stmt); .. The binary (prepared statement) ...