Search Results
https://dev.mysql.com/doc/refman/8.4/en/alter-tablespace.html
In MySQL 8.4, it is supported in the following two cases only: ALTER TABLESPACE tablespace_name ADD DATAFILE 'file_name' ENGINE={NDB|NDBCLUSTER} ALTER UNDO TABLESPACE tablespace_name SET {ACTIVE|INACTIVE} ENGINE=INNODB You should expect the eventual ...It can be used to add a new data file to, or to drop a data file from an NDB ...
https://dev.mysql.com/doc/refman/8.4/en/alter-view.html
ALTER [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}] [DEFINER = user] [SQL SECURITY { DEFINER | INVOKER }] VIEW view_name [(column_list)] AS select_statement [WITH [CASCADED | LOCAL] CHECK OPTION] This statement changes the definition of a view, ...
https://dev.mysql.com/doc/refman/8.4/en/checksum-table.html
You can use this statement to verify that the contents are the same before and after a backup, rollback, or other operation that is intended to put the data back to a known state. See Section 15.1.20, “CREATE TABLE Statement” for the syntax of ...[QUICK | EXTENDED] CHECKSUM TABLE reports a checksum for the contents of a ...
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 [=] ...For ...
https://dev.mysql.com/doc/refman/8.4/en/create-spatial-reference-system.html
srs_attribute: { NAME 'srs_name' | DEFINITION 'definition' | ORGANIZATION 'org_name' IDENTIFIED BY org_id | DESCRIPTION 'description' } srid, org_id: 32-bit unsigned integer This statement creates a spatial reference system (SRS) definition and ...
https://dev.mysql.com/doc/refman/8.4/en/declare-condition.html
CONDITION statement declares a named error condition, associating a name with a condition that needs specific handling. Condition names referred to in SIGNAL or use RESIGNAL statements must be associated with SQLSTATE values, not MySQL error codes.
https://dev.mysql.com/doc/refman/8.4/en/drop-function-loadable.html
DROP FUNCTION [IF EXISTS] function_name This statement drops the loadable function named function_name. (DROP FUNCTION is also used to drop stored functions; see Section 15.1.29, “DROP PROCEDURE and DROP FUNCTION Statements”.) DROP FUNCTION is ...It requires the DELETE privilege for the mysql system schema because it removes the row from the mysql.func system table that registers the ...
https://dev.mysql.com/doc/refman/8.4/en/drop-view.html
If any views named in the argument list do not exist, the statement fails with an error indicating by name which nonexisting views it was unable to drop, and no changes are made. To avoid this failure scenario, use IF EXISTS syntax in DROP VIEW ...
https://dev.mysql.com/doc/refman/8.4/en/fetch.html
This statement fetches the next row for the SELECT statement associated with the specified cursor (which must be open), and advances the cursor pointer. The number of columns retrieved by the SELECT statement must match the number of output ...If a ...
https://dev.mysql.com/doc/refman/8.4/en/return.html
RETURN expr The RETURN statement terminates execution of a stored function and returns the value expr to the function caller. There must be at least one RETURN statement in a stored function. This statement is not used in stored procedures, ...