Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-features-create-alter-drop-server.html
The statements CREATE SERVER, ALTER SERVER, and DROP SERVER are not written to the binary log, regardless of the binary logging format that is in use.
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-plugins-create.html
A plugin can only contain code in one language, so if you are creating an extension object with a mix of members defined in Python and members defined in JavaScript, you must store the members as separate language-appropriate plugins. MySQL Shell ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-read-replicas-creating.html
Create Read Replicas using addReplicaInstance(): Cluster.addReplicaInstance(instance, [options]) Examples Default Read Replica Defining a Replication Source for the Read Replica Defining the Recovery Method for Read Replicas Certificate-based ...
https://dev.mysql.com/doc/workbench/en/wb-creating-views.html
You can add views to a database either from the Physical Schemas section of the MySQL Model page or from the EER Diagram.
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-users-created-first-login.html
The Manager user: This user is the administrator of MySQL Enterprise Service Manager. The Agent user: MySQL Enterprise Monitor Agent broadcasts the status of the assets it is monitoring and requires access to MySQL Enterprise Service Manager. These ...
https://dev.mysql.com/doc/ndbapi/en/ndb-table.html
It is possible using the NDB API to create tables independently of the MySQL server. However, it is usually not advisable to do so, since tables created in this fashion cannot be seen by the MySQL server. As with other database objects, Table object ... This section provides information about the Table class, which models a database table in the NDB ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-foreign-keys.html
A duplicate symbol results in an error similar to: ERROR 1005 (HY000): Can't create table 'test.fk1' (errno: 121). Creating a foreign key constraint requires the REFERENCES privilege on the parent table. Such an index is created on the referencing ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...If ...
https://dev.mysql.com/doc/refman/8.4/en/server-system-variables.html
The following table shows some possible values for authentication_policy and the policy that each establishes for creating or altering accounts. CREATE TABLE and ALTER TABLE having a CHARACTER SET utf8mb4 clause without a COLLATION clause, either ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table.html
For example, you can add or delete columns, create or destroy indexes, change the type of existing columns, or rename columns or the table itself. To use ALTER TABLE, you need ALTER, CREATE, and INSERT privileges for the table. Renaming a table ...| ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-ndb-comment-options.html
NDB_COLUMN Options In NDB Cluster, a column comment in a CREATE TABLE or ALTER TABLE statement can also be used to specify an NDB_COLUMN option. NDB_TABLE Options For an NDB Cluster table, the table comment in a CREATE TABLE or ALTER TABLE statement ... NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB ...