Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations-storage-engines.html
CREATE TABLE and ALTER TABLE statements that would cause a user-partitioned NDB table not to meet either or both of the following two requirements are not permitted, and fail with an error: The table must have an explicit primary key. If a ...This ... In MySQL 8.4, partitioning support is not actually provided by the MySQL Server, but rather by a table storage engine's own or native partitioning ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-concepts.html
A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (the source). The tag is a user-defined string used to identify a specific group of transactions; see the ...This identifier is unique not only to the server on which it originated, but is unique across all servers in a given replication ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks-account.html
It is recommended that you never give any ACL privileges to the PRIVILEGE_CHECKS_USER account, including CREATE USER, CREATE ROLE, DROP ROLE, and GRANT OPTION, and do not permit the account to update the mysql.user table. With these privileges, the ... The user account that is specified using the CHANGE REPLICATION SOURCE TO statement as the PRIVILEGE_CHECKS_USER account for a replication channel must have the REPLICATION_APPLIER privilege, otherwise the replication applier thread does not ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.backup.html
We specify some of the connection information for the database using the --user and --host options (and, with the --password option, tell mysqlbackup to prompt for a user password). The unique ID for this backup job is recorded in special tables ...
https://dev.mysql.com/doc/relnotes/mysql-cluster/8.4/en/dynxml-auto-changelog-difflist-mysqld-8.4.4-ndb-8.4.4.html
(Bug #37049014) Bugs Fixed Microsoft Windows: Successive iterations of the sequence ndb_sign_keys --create-key followed by ndb_sign_keys --promote were unsuccessful on Windows. This fix also adds a warning to inform API users that deleting ...
https://dev.mysql.com/doc/relnotes/mysql-cluster/8.4/en/news-8-4-4.html
(Bug #37049014) Bugs Fixed Microsoft Windows: Successive iterations of the sequence ndb_sign_keys --create-key followed by ndb_sign_keys --promote were unsuccessful on Windows. This fix also adds a warning to inform API users that deleting ... MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-example-data.html
If no primary key is defined by the user when a table is created, the NDBCLUSTER storage engine automatically generates a hidden one. To specify this, use the ENGINE=NDBCLUSTER or ENGINE=NDB option when creating the table: CREATE TABLE tbl_name ...
https://dev.mysql.com/doc/refman/8.4/en/function-resolution.html
ADDDATE BIT_AND BIT_OR BIT_XOR CAST COUNT CURDATE CURTIME DATE_ADD DATE_SUB EXTRACT GROUP_CONCAT MAX MID MIN NOW POSITION SESSION_USER STD STDDEV STDDEV_POP STDDEV_SAMP SUBDATE SUBSTR SUBSTRING SUM SYSDATE SYSTEM_USER TRIM VARIANCE VAR_POP VAR_SAMP ... MySQL supports built-in (native) functions, loadable functions, and stored ...
https://dev.mysql.com/doc/refman/8.4/en/invisible-columns.html
However, even if explicitly referenced, a column that is invisible in the existing table is visible in the new table: mysql> CREATE TABLE t1 (col1 INT, col2 INT INVISIBLE); mysql> CREATE TABLE t2 AS SELECT col1, col2 FROM t1; mysql> SHOW CREATE ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-snippets.html
Users connected to this MySQL server are allowed to create, edit, and use these shared snippets. The My Snippets option stores custom snippets in a file under the MySQL Workbench user's configuration directory. Table 8.1 Default Local Snippet File ... The Snippets secondary tab includes built-in, local, and shared custom ...