Search Results
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]] ...
https://dev.mysql.com/doc/refman/8.4/en/creating-spatial-columns.html
Use the CREATE TABLE statement to create a table with a spatial column: CREATE TABLE geom (g GEOMETRY); Use the ALTER TABLE statement to add or drop a spatial column to or from an existing table: ALTER TABLE geom ADD pt POINT; ALTER TABLE geom DROP ... MySQL provides a standard way of creating spatial columns for geometry types, for example, with CREATE TABLE or ALTER ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-plugin-functions.html
Example: mysql> SELECT gen_dictionary('mydict'); +--------------------------+ | gen_dictionary('mydict') | +--------------------------+ | My term | +--------------------------+ mysql> SELECT gen_dictionary('no-such-dict'); ... The MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.4/en/diagnostics-area.html
SQL statements produce diagnostic information that populates the diagnostics area. Standard SQL has a diagnostics area stack, containing a diagnostics area for each nested execution context. Standard SQL also supports GET STACKED DIAGNOSTICS syntax ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-event-fields.html
Filter components may include or drop error events based on priority, except that system events are mandatory and cannot be dropped. Error events intended for the error log contain a set of fields, each of which consists of a key/value pair. An ...
https://dev.mysql.com/doc/refman/8.4/en/example-foreign-keys.html
To demonstrate ON DELETE and ON UPDATE referential actions, drop the child table and recreate it to include ON UPDATE and ON DELETE subclauses with the CASCADE option. MySQL supports foreign keys, which permit cross-referencing related data across ...