Search Results
https://dev.mysql.com/doc/refman/8.4/en/alter-table.html
The outcome of attempting to change the storage engine of a table is affected by whether the desired storage engine is available and the setting of the NO_ENGINE_SUBSTITUTION SQL mode, as described in Section 7.1.11, “Server SQL Modes”. Updates ... ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/relnotes/connector-odbc/en/news-8-0-30.html
Also improved BUNDLE_DEPENDENCIES and MAINTAINER_MODE CMake options to check if the required bundled plugins and 3rd party libraries are present. The value is set by libmysqlclient if not set, and has no effect with ssl-mode=DISABLED. (Bug #106886, ... Authentication Notes Character Set Support Compilation Notes Functionality Added or Changed Bugs Fixed Authentication Notes Password parameters escaped with curly braces did not escape right curly braces in the password ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/preface.html
This is the X DevAPI User Guide for MySQL Shell in JavaScript mode. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/preface.html
This is the X DevAPI User Guide for MySQL Shell in Python mode. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-formats.html
With mixed logging, statement-based logging is used by default, but the logging mode switches automatically to row-based in certain cases as described below. In deciding whether or not a given statement is safe for statement-based replication, MySQL ... The server uses several logging formats to record information in the binary log: Replication capabilities in MySQL originally were based on propagation of SQL statements from source to ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-recovery.html
If MySQL still has trouble starting because of InnoDB consistency problems, see Section 17.20.3, “Forcing InnoDB Recovery” for steps to start the instance in recovery mode, which permits you to dump the data. The current maximum auto-increment ...To achieve point-in-time recovery after restoring a backup, you can apply changes from the binary log that occurred after the backup was ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-background.html
The group can operate in a single-primary mode with automatic primary election, where only one server accepts updates at a time. Alternatively, for more advanced users the group can be deployed in multi-primary mode, where all servers can accept ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-commands.html
If you are running with --safe-updates enabled, status also prints the values for the mysql variables that affect your queries. For server side help, type 'help contents' If mysql is invoked with the --binary-mode option, all mysql commands are ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-error-handling.html
Row number and character position details are added to warning messages(Non strict mode) in csv and JSON file formats. Row number is added to warning messages(Non strict mode) in parquet or AVRO file formats. For example: mysql> SET ... See MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlcheck.html
This permits passwords to be specified in a safer way than on the command line even when --no-defaults is used. --ssl-fips-mode={OFF|ON|STRICT} Command-Line Format --ssl-fips-mode={OFF|ON|STRICT} Deprecated Yes Type Enumeration Default Value OFF ...