MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 181 to 190 of 593 total results

https://dev.mysql.com/doc/refman/8.0/en/create-index.html

CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... This guideline is especially important for InnoDB tables, where the primary key determines the ...

15.1.16 CREATE LOGFILE GROUP Statement

https://dev.mysql.com/doc/refman/8.0/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 [=] ...

15.1.20.4 CREATE TABLE ... SELECT Statement

https://dev.mysql.com/doc/refman/8.0/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 ...

15.1.22 CREATE TRIGGER Statement

https://dev.mysql.com/doc/refman/8.0/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 | ...

11.1.3 Date and Time Literals

https://dev.mysql.com/doc/refman/8.0/en/date-and-time-literals.html

Standard SQL and ODBC Date and Time Literals String and Numeric Literals in Date and Time Context Date and time values can be represented in several formats, such as quoted strings or as numbers, depending on the exact type of the value and other ...

15.2.2 DELETE Statement

https://dev.mysql.com/doc/refman/8.0/en/delete.html

DELETE is a DML statement that removes rows from a table. A DELETE statement can start with a WITH clause to define common table expressions accessible within the DELETE. Single-Table Syntax DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM tbl_name ...

10.2.2.5 Derived Condition Pushdown Optimization

https://dev.mysql.com/doc/refman/8.0/en/derived-condition-pushdown-optimization.html

MySQL 8.0.22 and later supports derived condition pushdown for eligible subqueries. When a derived table cannot be merged into the outer query (for example, if the derived table uses aggregation), pushing the outer WHERE condition down to the ...

14.13 Encryption and Compression Functions

https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html

If you want to store these results, use a column with a VARBINARY or BLOB binary string data type. This avoids potential problems with trailing space removal or character set conversion that would change data values, such as may occur if you use a ...

7.4.2.6 Rule-Based Error Log Filtering (log_filter_dragnet)

https://dev.mysql.com/doc/refman/8.0/en/error-log-rule-based-filtering.html

The log_filter_dragnet log filter component enables log filtering based on user-defined rules. To enable the log_filter_dragnet filter, first load the filter component, then modify the log_error_services value. The following example enables ...

8.4.7.4 MySQL Enterprise Firewall Reference

https://dev.mysql.com/doc/refman/8.0/en/firewall-reference.html

When enabled, the firewall bases operational decisions on the cached data. The firewall database can be the mysql system database or a custom schema (see Installing MySQL Enterprise Firewall). For information about MySQL Enterprise Firewall ...

Displaying 181 to 190 of 593 total results