PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/clone-plugin-stop.html
If necessary, you can stop a cloning operation with a KILL QUERY processlist_id statement. On the recipient MySQL server instance, you can retrieve the processlist identifier (PID) for a cloning operation from the PID column of the clone_status ...
https://dev.mysql.com/doc/refman/9.7/en/correlated-subqueries.html
The predicate must employ the equality operator = for making the comparison; the null-safe <=> operator is not supported in this context. A correlated subquery is a subquery that contains a reference to a table that also appears in the outer query.
https://dev.mysql.com/doc/refman/9.7/en/create-view.html
CREATE [OR REPLACE] [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}] [MATERIALIZED] ... If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE VIEW. If the view does exist, CREATE OR REPLACE VIEW replaces it. The select_statement is ...
https://dev.mysql.com/doc/refman/9.7/en/data-masking-plugin-usage.html
Before using MySQL Enterprise Data Masking, install it according to the instructions provided at Section 8.5.3.1, “MySQL Enterprise Data Masking Plugin Installation”. To use MySQL Enterprise Data Masking in applications, invoke the functions ...
https://dev.mysql.com/doc/refman/9.7/en/declare-local-variable.html
If the DEFAULT clause is missing, the initial value is NULL. type [DEFAULT value] This statement declares local variables within stored programs. To provide a default value for a variable, include a DEFAULT clause. The value can be specified as an ...
https://dev.mysql.com/doc/refman/9.7/en/delete.html
For example, to delete rows that exist in t1 that have no match in t2, use a LEFT JOIN: DELETE t1 FROM t1 LEFT JOIN t2 ON t1.id=t2.id WHERE t2.id IS NULL; The syntax permits .* after each tbl_name for compatibility with Access. DELETE is a DML ...
https://dev.mysql.com/doc/refman/9.7/en/diagnostics-area.html
SQL statements produce diagnostic information that populates the diagnostics area. Standard SQL has a diagnostics area stack, containing a diagnostics area for each nested execution context. Standard SQL also supports GET STACKED DIAGNOSTICS syntax ...
https://dev.mysql.com/doc/refman/9.7/en/drop-database.html
If the default database is dropped, the default database is unset (the DATABASE() function returns NULL). DROP {DATABASE | SCHEMA} [IF EXISTS] db_name DROP DATABASE drops all tables in the database and deletes the database. Be very careful with ...
https://dev.mysql.com/doc/refman/9.7/en/encrypted-connection-protocols-ciphers.html
If this variable is not set, its default value is NULL, which means that the server permits the default set of ciphersuites. MySQL supports multiple TLS protocols and ciphers, and enables configuring which protocols and ciphers to permit for ...
https://dev.mysql.com/doc/refman/9.7/en/example-foreign-keys.html
MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data consistent. A foreign key relationship involves a parent table that holds the initial column ...