Search Results
https://dev.mysql.com/doc/refman/9.7/en/mysql-command-options.html
--auto-vertical-output Command-Line Format --auto-vertical-output Cause result sets to be displayed vertically if they are too wide for the current window, and using normal tabular format otherwise. If auto-reconnect is enabled, the statement is ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-online-ddl-operations.html
INNODB_COLUMNS.DEFAULT_VALUE INNODB_COLUMNS.HAS_DEFAULT INNODB_TABLES.INSTANT_COLS Concurrent DML is not permitted when adding an auto-increment column. Dropping a column default value ALTER TABLE tbl ALTER COLUMN col DROP DEFAULT, ...The value is ... Online support details, syntax examples, and usage notes for DDL operations are provided under the following topics in this ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-last-insert-id.html
getGeneratedKeys() is the preferred method to use if you need to retrieve AUTO_INCREMENT keys and through JDBC; this is illustrated in the first example below. The final example shows how updatable result sets can retrieve the AUTO_INCREMENT value ...The second example shows how you can retrieve the same value using a standard SELECT LAST_INSERT_ID() ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-last-insert-id.html
getGeneratedKeys() is the preferred method to use if you need to retrieve AUTO_INCREMENT keys and through JDBC; this is illustrated in the first example below. The final example shows how updatable result sets can retrieve the AUTO_INCREMENT value ...The second example shows how you can retrieve the same value using a standard SELECT LAST_INSERT_ID() ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-overview.html
To learn how to use Lakehouse with MySQL HeatWave AutoML, see Use MySQL HeatWave AutoML with Lakehouse. Create the external table either using Auto Parallel Load or manually. Load the external files into Lakehouse either using Auto Parallel Load or ... The Lakehouse feature of MySQL HeatWave enables query processing on data in Object ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/backup-commands-update.html
See Section 5.1.3, “Restoring an Incremental Backup” for instructions on restoring incremental backups. For a single-file incremental backup, you typically use the copy-back-and-apply-log command to apply the data in the incremental image backup ... There are two types of operations to bring your backup data up-to-date: Apply-log Operation After a backup job was first completed, the backup data might not be in a consistent state, because data could have been inserted, updated, or deleted while the backup was ...
https://dev.mysql.com/doc/refman/9.7/en/set-variable.html
The following procedure uses the increment procedure parameter and counter local variable: CREATE PROCEDURE p(increment INT) BEGIN DECLARE counter INT DEFAULT 0; WHILE counter < 10 DO -- ... SET counter = counter + increment; END WHILE; END; System ...variable: { user_var_name | param_name | local_var_name | {GLOBAL | @@GLOBAL.} system_var_name | {PERSIST | @@PERSIST.} system_var_name | {PERSIST_ONLY | @@PERSIST_ONLY.} system_var_name | [SESSION | ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-relnotes.html
2025-06-25: New Way to List Available GenAI Models MySQL HeatWave GenAI now supports automated discovery and listing of all available in-database and AWS Bedrock LLMs and embedding models starting with MySQL 9.3.2. It assures that when the primary ... Release Notes 23 Release Notes Release notes for MySQL HeatWave on AWS 2025-08-26: Data Storage Size Can Now Be Increased For Highly Available DB Systems You can now increase the data storage size of a highly available DB System ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-enterprise-backup.html
For example, on Linux distributions that use systemd: s3> systemctl stop mysqld Preserve the two configuration files in the corrupted server's data directory, auto.cnf and mysqld-auto.cnf (if it exists), by copying them to a safe location outside of ... MySQL Enterprise Backup is a commercially-licensed backup utility for MySQL Server, available with MySQL Enterprise ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-options-variables.html
ndb_autoincrement_prefetch_sz Command-Line Format --ndb-autoincrement-prefetch-sz=# System Variable ndb_autoincrement_prefetch_sz Scope Global, Session Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 512 Minimum Value 1 Maximum Value ...If the SQL node and the data node use the same host name or IP address, this fact is detected automatically, so that the preference is to send reads to the same ...