PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-desc.html
Three of the table properties that can be set using NDB_TABLE comments embedded in CREATE TABLE and ALTER TABLE statements are also visible in ndb_desc output. You can check that the ALTER TABLE statement has the desired effect using SHOW CREATE ...
https://dev.mysql.com/doc/refman/8.0/en/rename-table.html
You must have ALTER and DROP privileges for the original table, and CREATE and INSERT privileges for the new table. RENAME TABLE tbl_name TO new_tbl_name [, tbl_name2 TO new_tbl_name2] ... As of MySQL 8.0.13, you can rename tables locked with a ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-invoked.html
The following statements are replicated using statement-based replication: CREATE EVENT ALTER EVENT DROP EVENT CREATE PROCEDURE DROP PROCEDURE CREATE FUNCTION DROP FUNCTION CREATE TRIGGER DROP TRIGGER However, the effects of features created, ...
https://dev.mysql.com/doc/refman/8.0/en/resource-groups.html
Resource Group Elements These capabilities provide the SQL interface for resource group management in MySQL: SQL statements enable creating, altering, and dropping resource groups, and enable assigning threads to resource groups. MySQL supports ...
https://dev.mysql.com/doc/refman/8.0/en/stored-program-restrictions.html
An event may not be altered, or dropped from within a stored program, if the event name is specified by means of a variable. An event also may not create, alter, or drop stored routines or triggers. (Bug #16396) References to stored functions, ...
https://dev.mysql.com/doc/refman/8.0/en/converting-tables-to-innodb.html
If an ALTER TABLE operation runs out of space, it starts a rollback, and that can take hours if it is disk-bound. Declare the PRIMARY KEY clause in the original CREATE TABLE statement, rather than adding it later through an ALTER TABLE statement.
https://dev.mysql.com/doc/refman/8.0/en/create-event.html
This is true for both CREATE EVENT and ALTER EVENT statements. Alternatively, you can use ENABLE to make explicit the default status, which is active. This is most useful in conjunction with ALTER EVENT (see Section 15.1.3, “ALTER EVENT ... CREATE ...
https://dev.mysql.com/doc/refman/8.0/en/drop-index.html
This statement is mapped to an ALTER TABLE statement to drop the index. They have the same meaning as for the ALTER TABLE statement. For more information, see Section 15.1.9, “ALTER TABLE Statement” MySQL NDB Cluster supports online operations ...algorithm_option: ALGORITHM [=] {DEFAULT | INPLACE | COPY} lock_option: LOCK [=] {DEFAULT | NONE | SHARED | EXCLUSIVE} DROP INDEX drops the index named index_name from the table ...
https://dev.mysql.com/doc/refman/8.0/en/expired-password-handling.html
For example: ALTER USER 'myuser'@'localhost' PASSWORD EXPIRE; For each connection that uses an account with an expired password, the server either disconnects the client or restricts the client to “sandbox mode,” in which the server permits the ... MySQL provides password-expiration capability, which enables database administrators to require that users reset their ...
https://dev.mysql.com/doc/refman/8.0/en/explain-output.html
To fix this disparity between column lengths, use ALTER TABLE to lengthen ActualPC from 10 characters to 15 characters: mysql> ALTER TABLE tt MODIFY ActualPC VARCHAR(15); Now tt.ActualPC and et.EMPLOYID are both VARCHAR(15). The EXPLAIN statement ...