Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-restrictions-limitations.html
You cannot create a table with a column name that matches the name of an internal InnoDB column (including DB_ROW_ID, DB_TRX_ID, and DB_ROLL_PTR. mysql> CREATE TABLE t1 (c1 INT, db_row_id INT) ENGINE=INNODB; ERROR 1166 (42000): Incorrect column name ... This section describes restrictions and limitations of the InnoDB storage ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-move-data.html
Usage The program is invoked with the names of the source and target tables; either or both of these may be qualified optionally with the database name. ndb_move_data options source target Options that can be used with ndb_move_data are shown in the ...--abort-on-error Command-Line Format --abort-on-error Dump core on permanent error (debug ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/meb-backup-osb.html
Each time an online backup is made to a tape using the SBT API , besides recording the backup in the mysql.backup_history and the mysql.backup_progress tables, an entry is also made to the mysql.backup_sbt_history table on the backed up MySQL ...
https://dev.mysql.com/doc/mysqld-version-reference/en/keywords.html
The following table shows all keywords and reserved words available in MySQL Server. This section contains information on the keywords and reserved words within the server when creating and submitting queries to the system. For more information on ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-prereqs.html
Model and Table Sizes The table used to train a model cannot exceed 10 GB, 100 million rows, or 1017 columns. Data Requirements Each dataset must reside in a single table on the DB System. Refer to the appropriate MySQL version for maximum MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/create-procedure.html
The following example shows a simple stored procedure that, given a country code, counts the number of cities for that country that appear in the city table of the world database. This prohibition includes SELECT statements that do not have an INTO ...By default, a stored routine is associated with the default ...
https://dev.mysql.com/doc/relnotes/mysql-cluster/8.4/en/news-8-4-5.html
(Bug #37112446) ndbinfo Information Database: Certain queries against ndbinfo tables were not handled correctly. With this fix, after a connection has been established, ClusterJ reports the actual assigned node ID in the log. (Bug #37518267) When ...
https://dev.mysql.com/doc/ndbapi/en/ndb-undofile.html
Undofile Class Overview Undofile Constructor Undofile::getFileNo() (OBSOLETE) Undofile::getLogfileGroup() Undofile::getLogfileGroupId() Undofile::getNode() (OBSOLETE) Undofile::getObjectId() Undofile::getObjectStatus() Undofile::getObjectVersion() ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-access.html
Preparing a Microsoft Access Database for Migration Microsoft Access stores relationship/foreign key information in an internal table called MSysRelationships. That table is protected against read access even to the Admin user, so if you try to ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-last-insert-id.html
The final example shows how updatable result sets can retrieve the AUTO_INCREMENT value when using the insertRow() method. getGeneratedKeys() is the preferred method to use if you need to retrieve AUTO_INCREMENT keys and through JDBC; this is ...