Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-create-trigger.html
row *************************** Trigger: ins_sum sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION SQL Original Statement: CREATE DEFINER=`me`@`localhost` TRIGGER ...
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/creating-spatial-indexes.html
For InnoDB and MyISAM tables, MySQL can create spatial indexes using syntax similar to that for creating regular indexes, but using the SPATIAL keyword. For storage engines that support nonspatial indexing of spatial columns, the engine creates a ...A B-tree index on spatial values is useful for exact-value lookups, but not for range ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-database.html
SHOW CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name Shows the CREATE DATABASE statement that creates the named database. row *************************** Database: test Create Database: CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET ...If ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-hwaml-create-model.html
Create a MySQL HeatWave AutoML model 13.2 Create a MySQL HeatWave AutoML model Use the MySQL HeatWave Console to create a new MySQL HeatWave AutoML model. Create a MySQL HeatWave AutoML model includes an advanced option to choose one or more ...
https://dev.mysql.com/doc/internals/en/creating-tables.html
Once a handler is instanced, the first operation that will likely be required is the creation of a table. Your storage engine must implement the [custom-engine.html#custom-engine-api-reference-create create()] virtual method: virtual int ...The ...
https://dev.mysql.com/doc/x-devapi-userguide/en/creating-documents.html
Once a collection has been created, it can store JSON documents. The most convenient way to create them is by calling the Collection.newDoc(). For strictly-typed languages it is possible to create class files based on the document structure ...You ...
https://dev.mysql.com/doc/refman/8.4/en/federated-create.html
To create a FEDERATED table you should follow these steps: Create the table on the remote server. Alternatively, make a note of the table definition of an existing table, perhaps using the SHOW CREATE TABLE statement. Create the table on the local ...Note You can improve the performance of a FEDERATED table by adding indexes to the table on the ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-cluster-setup-creating.html
In this section, we discuss the procedure for using MySQL Cluster Manager to create and start a new MySQL NDB Cluster. Note You can create and start a MySQL NDB Cluster on a single host for testing or similar purposes, simply by invoking mcmd with ...We assume that you have already obtained the MySQL Cluster Manager and MySQL NDB Cluster software, and that you are already familiar with installing MySQL Cluster Manager (see Chapter 3, MySQL Cluster Manager Installation, Configuration, Cluster ...
https://dev.mysql.com/doc/refman/8.4/en/creating-ssl-rsa-files-using-mysql.html
Files created automatically by the server are owned by the account that runs the server. MySQL provides these ways to create the SSL certificate and key files and RSA key-pair files required to support encrypted connections using SSL and secure ...