Search Results
https://dev.mysql.com/doc/refman/9.7/en/create-index.html
{ "user":"Bob", "user_id":31, "zipcode":[94477,94536] } Creating multi-valued Indexes You can create a multi-valued index in a CREATE TABLE, ALTER TABLE, or CREATE INDEX statement. CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ...This guideline is especially important for InnoDB tables, where the primary key determines the physical layout of rows in the data ...
https://dev.mysql.com/doc/refman/9.7/en/create-table.html
(Some valid select or union statement) CREATE TABLE creates a table with the given name. By default, tables are created in the default database, using the InnoDB storage engine. For information about the physical representation of a table, see ...| ...
https://dev.mysql.com/doc/refman/9.7/en/proxy-users.html
Use the CREATE USER statement to associate an account with an authentication plugin, or ALTER USER to change its plugin. For example: GRANT PROXY ON 'proxied_user' TO 'proxy_user'; The statement creates a row in the mysql.proxies_priv grant table.
https://dev.mysql.com/doc/refman/9.7/en/create-tablespace.html
If the directory specified does not exist, NDB attempts to create it; the system user account under which the data node process is running must have the appropriate permissions to do so. Considerations for InnoDB Considerations for NDB Cluster ...
https://dev.mysql.com/doc/refman/9.7/en/create-view.html
If the DEFINER clause is omitted, the default definer is the user who executes the CREATE VIEW statement. CREATE [OR REPLACE] [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}] [MATERIALIZED] ... If the view does not exist, CREATE OR REPLACE VIEW is the ...The select_statement is a SELECT statement that provides the definition of the ...
https://dev.mysql.com/doc/refman/9.7/en/create-event.html
CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON {REPLICA | SLAVE}] [COMMENT 'string'] DO event_body schedule: { AT timestamp [+ INTERVAL interval] ... If ...
https://dev.mysql.com/doc/refman/9.7/en/create-trigger.html
CREATE [DEFINER = user] TRIGGER [IF NOT EXISTS] trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW [trigger_order] trigger_body trigger_time: { BEFORE | AFTER } trigger_event: { INSERT | UPDATE | DELETE } trigger_order: { FOLLOWS | ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-channel.html
Username: Specify the replication username for the account that you created on the MySQL source server. Creating a Channel 8.5 Creating a Channel Note:In MySQL replication, a replica is a MySQL server that receives changes from another MySQL server ...In MySQL HeatWave on AWS, a Channel references the replica as the target DB ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-create-mysql-configuration.html
User-defined variables are those that have ever been set in the dialog when the configuration was created. Creating a MySQL Configuration 19.1 Creating a MySQL Configuration Use the MySQL HeatWave Console to create a new MySQL configuration. You ...
https://dev.mysql.com/doc/refman/9.7/en/create-table-select.html
You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl; MySQL creates new columns for all elements in the SELECT. For example: mysql> CREATE ...