Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-table-generated-columns.html
For INSERT, REPLACE, and UPDATE, if a generated column is inserted into, replaced, or updated explicitly, the only permitted value is DEFAULT. Values of a generated column are computed from an expression included in the column definition. Generated ...
https://dev.mysql.com/doc/refman/8.4/en/create-trigger.html
These trigger_event values are permitted: INSERT: The trigger activates whenever a new row is inserted into the table (for example, through INSERT, LOAD DATA, and REPLACE statements). DELETE: The trigger activates whenever a row is deleted from the ... 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 | PRECEDES } other_trigger_name This statement creates a new ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-plugin-function-reference.html
Table 8.47 MySQL Enterprise Data Masking and De-Identification Plugin Functions Name Description Deprecated gen_blacklist() Perform dictionary term replacement Yes gen_blocklist() Perform dictionary term replacement gen_dictionary_drop() Remove ...
https://dev.mysql.com/doc/refman/8.4/en/default-privileges.html
Replace root-password in the examples with the password that you want to use. The MySQL installation process involves initializing the data directory, including the grant tables in the mysql system schema that define MySQL accounts. This section ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-configuration.html
[mysqld] log_error_services='log_filter_internal; log_sink_internal; log_sink_json' Note To use the JSON log sink (log_sink_syseventlog) instead of the default sink (log_sink_internal), you would replace log_sink_internal with log_sink_json. SET ...
https://dev.mysql.com/doc/refman/8.4/en/explain-extended.html
Extended information is available for SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. SHOW WARNINGS displays an empty result for other explainable statements (DELETE, INSERT, REPLACE, and UPDATE). The EXPLAIN statement produces extra ...
https://dev.mysql.com/doc/refman/8.4/en/explain-for-connection.html
To obtain the execution plan for an explainable statement executing in a named connection, use this statement: EXPLAIN [options] FOR CONNECTION connection_id; EXPLAIN FOR CONNECTION returns the EXPLAIN information that is currently being used to ...
https://dev.mysql.com/doc/refman/8.4/en/gone-away.html
An INSERT or REPLACE statement that inserts a great many rows can also cause these sorts of errors. Either one of these statements sends a single request to the server irrespective of the number of rows to be inserted; thus, you can often avoid the ... This section also covers the related Lost connection to server during query ...
https://dev.mysql.com/doc/refman/8.4/en/information-functions.html
For REPLACE statements, the affected-rows value is 2 if the new row replaced an old row, because in this case, one row was inserted after the duplicate was deleted. It may be used to time how quickly MySQL processes the expression. The result value ...
https://dev.mysql.com/doc/refman/8.4/en/join.html
MySQL supports the following JOIN syntax for the table_references part of SELECT statements and multiple-table DELETE and UPDATE statements: table_references: escaped_table_reference [, escaped_table_reference] ... index_hint: { USE {INDEX|KEY} ...