Search Results
https://dev.mysql.com/doc/ndbapi/en/ndb-column.html
Column::getAutoIncrement() Description This method shows whether the column is an auto-increment column. Return value TRUE if the column is an auto-increment column, FALSE if it is not. Signature void setAutoIncrement ( bool flag ) Parameters A ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/schema-advisor-ref.html
MySQL's mechanism for doing this is the AUTO_INCREMENT column attribute, which enables you to generate sequential numbers automatically. If you try to generate a number that exceeds the maximum allowed by the underlying data type, such as by ...
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. As of MySQL 9.4.0, you can use the CREATE EXTERNAL TABLE statement, which automatically sets ENGINE to lakehouse, and SECONDARY_ENGINE to rapid.
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax-sql.html
CREATE EXTERNAL TABLE table_name (col_name data_type ['Col_Options_SQL'], ...) Tbl_Options_SQL; The CREATE EXTERNAL TABLE statement automatically sets ENGINE to lakehouse and SECONDARY_ENGINE to rapid. mysql> CREATE EXTERNAL TABLE table_1( col_1 ...
https://dev.mysql.com/doc/refman/8.4/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/mysql-enterprise-backup/8.4/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/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/mysql-monitor/8.0/en/replication-advisor-ref.html
Default frequency 06:00:00 Default auto-close enabled yes Binary Log File Count Exceeds Specified Limit The binary log captures DML, DDL, and security changes that occur and stores these changes in a binary format. Default frequency 06:00:00 Default ...By default, the server logs the length of the event as well as the event itself and uses this information to verify that the event was written ...
https://dev.mysql.com/doc/refman/8.4/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 ...