Search Results
https://dev.mysql.com/doc/refman/8.4/en/alter-function.html
However, you cannot change the parameters or body of a stored function using this statement; to make such changes, you must drop and re-create the function using DROP FUNCTION and CREATE FUNCTION. ALTER FUNCTION func_name [characteristic ...] ...
https://dev.mysql.com/doc/refman/8.4/en/alter-procedure.html
However, you cannot change the parameters or body of a stored procedure using this statement; to make such changes, you must drop and re-create the procedure using DROP PROCEDURE and CREATE PROCEDURE. ALTER PROCEDURE proc_name [characteristic ...] ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-failure-handling.html
If the operation does not resume within the allotted time, it aborts and returns an error, and the donor drops the snapshot. A setting of zero causes the donor to drop the snapshot immediately when a network error occurs. This section describes ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-monitoring.html
The stages of a cloning operation include DROP DATA, FILE COPY, PAGE_COPY, REDO_COPY, FILE_SYNC, RESTART, and RECOVERY. You can monitor the status and progress of a cloning operation on the recipient MySQL server instance using the clone_status and ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-options-variables.html
clone_delay_after_data_drop Command-Line Format --clone-delay-after-data-drop System Variable clone_delay_after_data_drop Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 0 Minimum Value 0 Maximum Value 3600 Unit bytes ...
https://dev.mysql.com/doc/refman/8.4/en/compressed-format.html
For example, you may still use DROP to drop the table, and TRUNCATE TABLE to empty the table. Compressed storage format is a read-only format that is generated with the myisampack tool. Compressed tables have the following characteristics: ...
https://dev.mysql.com/doc/refman/8.4/en/create-function-loadable.html
Note To upgrade the shared library associated with a loadable function, issue a DROP FUNCTION statement, upgrade the shared library, and then issue a CREATE FUNCTION statement. If you upgrade the shared library first and then use DROP FUNCTION, the ... CREATE [AGGREGATE] FUNCTION [IF NOT EXISTS] function_name RETURNS {STRING|INTEGER|REAL|DECIMAL} SONAME shared_library_name This statement loads the loadable function named ...
https://dev.mysql.com/doc/refman/8.4/en/create-logfile-group.html
CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] [UNDO_BUFFER_SIZE [=] undo_buffer_size] [REDO_BUFFER_SIZE [=] redo_buffer_size] [NODEGROUP [=] nodegroup_id] [WAIT] [COMMENT [=] 'string'] ENGINE [=] ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-gipks.html
Whenever GIPKs are enabled, you cannot drop a generated primary key if either of the following 2 conditions would result: The table is left with no primary key. The primary key is dropped, but not the primary key column. MySQL 8.4 supports ...
https://dev.mysql.com/doc/refman/8.4/en/create-user.html
To perform the user-creation operation without either of these, drop the orphan objects, create the account and grant its privileges, and then re-create the dropped objects. CREATE USER [IF NOT EXISTS] user [auth_option] [, user [auth_option]] ...