Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-table-select.html
This follows the same rules as with VALUES; all columns of the source table and their names in the source table are always inserted into the new table. SELECT, if IF NOT EXISTS is given and the target table exists, nothing is inserted into the ...
https://dev.mysql.com/doc/refman/8.4/en/create-view.html
This same principle applies to options such as ALL, DISTINCT, or SQL_SMALL_RESULT that follow the SELECT keyword, and to clauses such as INTO, FOR UPDATE, FOR SHARE, LOCK IN SHARE MODE, and PROCEDURE. If the view does not exist, CREATE OR REPLACE ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-plugin-functions.html
The MySQL Enterprise Data Masking and De-Identification plugin library includes several functions, which may be grouped into these categories: Data Masking Plugin Functions Random Data Generation Plugin Functions Random Data Dictionary-Based Plugin ...If a string return value should be in a different character set, convert ...
https://dev.mysql.com/doc/refman/8.4/en/declare-handler.html
statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ... HANDLER statement specifies a handler that deals ...
https://dev.mysql.com/doc/refman/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/derived-tables.html
For information about lateral derived tables preceded by the LATERAL keyword, see Section 15.2.15.9, “Lateral Derived Tables”. A derived table is an expression that generates a table within the scope of a query FROM clause. For example, a ...
https://dev.mysql.com/doc/refman/8.4/en/docker-mysql-more-topics.html
Running Additional Initialization Scripts If there are any .sh or .sql scripts you want to run on the database immediately after it has been created, you can put them into a host directory and then mount the directory at /docker-entrypoint-initdb.d/ ...A MySQL Docker installation is different from a common, non-Docker installation in the following aspects: Only a limited number of binaries are ...
https://dev.mysql.com/doc/refman/8.4/en/enterprise-encryption-usage.html
To use MySQL Enterprise Encryption in applications, invoke the functions that are appropriate for the operations you wish to perform. MySQL Enterprise Encryption functions are provided by a MySQL component component_enterprise_encryption. For ...
https://dev.mysql.com/doc/refman/8.4/en/error-message-elements.html
The set of error codes used in error messages is partitioned into distinct ranges; see Error Code Ranges. Error Code Ranges The set of error codes used in error messages is partitioned into distinct ranges, each with its own purpose: 1 to 999: ...
https://dev.mysql.com/doc/refman/8.4/en/extensions-to-ansi.html
MySQL Server supports some extensions that you are not likely to find in other SQL DBMSs. Be warned that if you use them, your code is most likely not portable to other SQL servers. For example, MySQL Server recognizes the STRAIGHT_JOIN keyword in ...