Search Results
https://dev.mysql.com/doc/refman/8.4/en/data-masking-component-function-reference.html
Table 8.46 MySQL Enterprise Data Masking and De-Identification Component Functions Name Description gen_blocklist() Perform dictionary term replacement gen_dictionary() Return random term from dictionary gen_range() Generate random number within ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-literals.html
This section describes the acceptable formats for date and time literals. The following alternative formats are also understood: ss, mmss, or hhmmss. You can specify a time zone offset when inserting TIMESTAMP and DATETIME values into a table.
https://dev.mysql.com/doc/refman/8.4/en/debugging-server.html
This command also provides some useful information even if you have not compiled MySQL for debugging! If the problem is that some tables are getting slower and slower you should try to optimize the table with OPTIMIZE TABLE or myisamchk. If you are ...
https://dev.mysql.com/doc/refman/8.4/en/declare-handler.html
It can take the following forms: mysql_error_code: An integer literal indicating a MySQL error code, such as 1051 to specify “unknown table”: DECLARE CONTINUE HANDLER FOR 1051 BEGIN -- body of handler END; Do not use MySQL error code 0 because ...statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ...
https://dev.mysql.com/doc/refman/8.4/en/differences-from-ansi.html
For example, in MySQL, privileges for a table are not automatically revoked when you delete a table. You must explicitly issue a REVOKE statement to revoke privileges for a table. We try to make MySQL Server follow the ANSI SQL standard and the ...
https://dev.mysql.com/doc/refman/8.4/en/distinct-optimization.html
DISTINCT combined with ORDER BY needs a temporary table in many cases. If you do not use columns from all tables named in a query, MySQL stops scanning any unused tables as soon as it finds the first match. Because DISTINCT may use GROUP BY, learn ...
https://dev.mysql.com/doc/refman/8.4/en/document-store-concepts.html
The most important differences between a document and the tables known from traditional relational databases are that the structure of a document does not have to be defined in advance, and a collection can contain multiple documents with different ... This section explains the concepts introduced as part of using MySQL as a document ...
https://dev.mysql.com/doc/refman/8.4/en/drop-server.html
Dropping a server for a table does not affect any FEDERATED tables that used this connection information when they were created. DROP SERVER [ IF EXISTS ] server_name Drops the server definition for the server named server_name. DROP SERVER is not ...
https://dev.mysql.com/doc/refman/8.4/en/drop-trigger.html
DROP TRIGGER requires the TRIGGER privilege for the table associated with the trigger. Triggers for a table are also dropped if you drop the table. DROP TRIGGER [IF EXISTS] [schema_name.]trigger_name This statement drops a trigger. If the schema is ...
https://dev.mysql.com/doc/refman/8.4/en/error-log.html
For example, if mysqld notices that a table needs to be automatically checked or repaired, it writes a message to the error log. Depending on error log configuration, error messages may also populate the Performance Schema error_log table, to ...