Search Results
https://dev.mysql.com/doc/refman/8.4/en/creating-database.html
(Under Windows, this restriction does not apply, although you must refer to databases and tables using the same lettercase throughout a given query. Alternatively, you can select the database on the command line when you invoke mysql. If the ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary.html
In previous MySQL releases, dictionary data was stored in metadata files, nontransactional tables, and storage engine-specific data dictionaries. MySQL Server incorporates a transactional data dictionary that stores information about database ...
https://dev.mysql.com/doc/refman/8.4/en/data-directory.html
Information managed by the MySQL server is stored under a directory known as the data directory. The following list briefly describes the items typically found in the data directory, with cross references for additional information: Data directory ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-component-variables.html
For additional information about setting up the data-masking components to use an alternative location for the data-masking table, see Install Using a Dedicated Schema. The MySQL Enterprise Data Masking and De-Identification components support the ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-components-vs-plugin.html
Previously, MySQL enabled masking and de-identification capabilities using a server-side plugin, but transitioned to use the component infrastructure as an alternative implementation. The following table briefly compares MySQL Enterprise Data ...It ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-types.html
Unpredictable results may occur if you use values in other formats. The following table shows the format of the “zero” value for each type. The “zero” values are special, but you can store or refer to them explicitly using the values shown ... The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and ...
https://dev.mysql.com/doc/refman/8.4/en/declare-condition.html
DECLARE condition_name CONDITION FOR condition_value condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value } The DECLARE ... CONDITION statement declares a named error condition, associating a name with a condition that needs ...
https://dev.mysql.com/doc/refman/8.4/en/disk-issues.html
If your computer is reasonably stable, this should give you better performance without sacrificing too much reliability. This section describes ways to configure storage devices when you can devote more and faster storage hardware to the database ...
https://dev.mysql.com/doc/refman/8.4/en/document-store.html
This chapter introduces an alternative way of working with MySQL as a document store, sometimes referred to as “using NoSQL”. This differs from working with a relational database and storing products in a table, when all columns of the table ...
https://dev.mysql.com/doc/refman/8.4/en/enterprise-encryption-installation.html
To install the component, issue this INSTALL COMPONENT statement: INSTALL COMPONENT "file://component_enterprise_encryption"; INSTALL COMPONENT requires the INSERT privilege for the mysql.component system table because it adds a row to that table to ... The functions are provided by a MySQL component component_enterprise_encryption, and installing the component installs all of the ...