Search Results
https://dev.mysql.com/doc/refman/8.4/en/data-masking.html
Various employee roles within both the card processing company and the financial institution require access to that data. Note MySQL Enterprise Data Masking and De-Identification is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.4/en/data-type-defaults.html
Literals, built-in functions (both deterministic and nondeterministic), and operators are permitted. Data type specifications can have explicit or implicit default values. A DEFAULT value clause in a data type specification explicitly indicates a ...
https://dev.mysql.com/doc/refman/8.4/en/database-use.html
It is available in both compressed tar file and Zip formats at https://dev.mysql.com/doc/. Once you know how to enter SQL statements, you are ready to access a database. Suppose that you have several pets in your home (your menagerie) and you would ...
https://dev.mysql.com/doc/refman/8.4/en/date-calculations.html
MySQL provides several functions that you can use to perform calculations on dates, for example, to calculate ages or extract parts of dates. To determine how many years old each of your pets is, use the TIMESTAMPDIFF() function. Its arguments are ...
https://dev.mysql.com/doc/refman/8.4/en/derived-condition-pushdown-optimization.html
This includes WHERE conditions having multiple predicates joined with AND, OR, or both. 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 ...
https://dev.mysql.com/doc/refman/8.4/en/descending-indexes.html
Descending indexes are supported for ordinary (nongenerated) and generated columns (both VIRTUAL and STORED). MySQL supports descending indexes: DESC in an index definition is no longer ignored but causes storage of key values in descending order.
https://dev.mysql.com/doc/refman/8.4/en/disk-issues.html
This makes both the seek and read times better, assuming that the disk is not used for other purposes as well. This section describes ways to configure storage devices when you can devote more and faster storage hardware to the database server. For ...
https://dev.mysql.com/doc/refman/8.4/en/document-store.html
X Protocol supports both CRUD and SQL operations, authentication via SASL, allows streaming (pipelining) of commands and is extensible on the protocol and the message layer. This chapter introduces an alternative way of working with MySQL as a ...
https://dev.mysql.com/doc/refman/8.4/en/drop-database.html
If you use DROP DATABASE on a symbolically linked database, both the link and the original database are deleted. DROP {DATABASE | SCHEMA} [IF EXISTS] db_name DROP DATABASE drops all tables in the database and deletes the database. Be very careful ...
https://dev.mysql.com/doc/refman/8.4/en/end-markers-in-json-system-variable.html
This variable affects both optimizer traces and the output of EXPLAIN FORMAT=JSON. When reading a very large JSON document, it can be difficult to pair its closing bracket and opening brackets; setting end_markers_in_json=ON repeats the structure's ...