Search Results
https://dev.mysql.com/doc/refman/8.4/en/archive-storage-engine.html
When you create an ARCHIVE table, the storage engine creates files with names that begin with the table name. Attempting to create an index on any other column results in an error. The ARCHIVE engine also supports the AUTO_INCREMENT table option in ... The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small ...
https://dev.mysql.com/doc/refman/8.4/en/change-replication-filter.html
Multiple replication filtering rules can be created in a single CHANGE REPLICATION FILTER statement by separating the rules with commas, as shown here: CHANGE REPLICATION FILTER REPLICATE_DO_DB = (d1), REPLICATE_IGNORE_DB = (d2); Issuing the ...
https://dev.mysql.com/doc/refman/8.4/en/cost-model.html
The primary key for the server_cost table is the cost_name column, so it is not possible to create multiple entries for any cost estimate. The server recognizes these cost_name values for the server_cost table: disk_temptable_create_cost, ... To ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-plugin-usage.html
Creating Views that Display Masked Data If masked data from a table is used for multiple queries, it may be convenient to define a view that produces masked data. Before using MySQL Enterprise Data Masking and De-Identification, install it ...
https://dev.mysql.com/doc/refman/8.4/en/declare-handler.html
statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ... HANDLER statement specifies a handler that deals ...
https://dev.mysql.com/doc/refman/8.4/en/drop-database.html
The DROP DATABASE statement removes from the given database directory those files and directories that MySQL itself may create during normal operation. Dropping a database does not remove any TEMPORARY tables that were created in that database.
https://dev.mysql.com/doc/refman/8.4/en/events-metadata.html
The session time zone that is current when a CREATE EVENT or ALTER EVENT statement executes is used to interpret times specified in the event definition. Value EVENTS Table SHOW EVENTS Execute at ETZ ETZ Starts ETZ ETZ Ends ETZ ETZ Last executed ETZ ... To obtain metadata about events: Query the EVENTS table of the INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/8.4/en/example-auto-increment.html
To start with an AUTO_INCREMENT value other than 1, set that value with CREATE TABLE or ALTER TABLE, like this: mysql> ALTER TABLE tbl AUTO_INCREMENT = 100; InnoDB Notes For information about AUTO_INCREMENT usage specific to InnoDB, see Section ...
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 ...
https://dev.mysql.com/doc/refman/8.4/en/gis-general-property-functions.html
For example: SET @g1 = ST_SRID(Point(1, 1), 4326); However, that method creates the geometry in SRID 0, then casts it to SRID 4326 (WGS 84). A preferable alternative is to create the geometry with the correct spatial reference system to begin with.