Search Results
https://dev.mysql.com/doc/refman/9.7/en/data-dictionary.html
MySQL Server incorporates a transactional data dictionary that stores information about database objects. In previous MySQL releases, dictionary data was stored in metadata files, nontransactional tables, and storage engine-specific data ...
https://dev.mysql.com/doc/refman/9.7/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 ...
https://dev.mysql.com/doc/refman/9.7/en/data-masking-components.html
Developers who wish to incorporate the same service functions used by component_masking should consult the internal\components\masking\component_masking.h file in a MySQL source distribution or https://dev.mysql.com/doc/dev/mysql-server/latest.
https://dev.mysql.com/doc/refman/9.7/en/data-masking-plugin.html
MySQL Enterprise Data Masking is based on a plugin library that implements these elements: A server-side plugin named data_masking. A set of loadable functions provides an SQL-level API for performing masking and de-identification operations.
https://dev.mysql.com/doc/refman/9.7/en/delete.html
Modifiers The DELETE statement supports the following modifiers: If you specify the LOW_PRIORITY modifier, the server delays execution of the DELETE until no other clients are reading from the table. DELETE is a DML statement that removes rows from ...
https://dev.mysql.com/doc/refman/9.7/en/drop-database.html
DROP {DATABASE | SCHEMA} [IF EXISTS] db_name DROP DATABASE drops all tables in the database and deletes the database. Be very careful with this statement! To use DROP DATABASE, you need the DROP privilege on the database. Important When a database ...
https://dev.mysql.com/doc/refman/9.7/en/drop-event.html
The event immediately ceases being active, and is deleted completely from the server. DROP EVENT [IF EXISTS] event_name This statement drops the event named event_name. If the event does not exist, the error ERROR 1517 (HY000): Unknown event ...
https://dev.mysql.com/doc/refman/9.7/en/error-access-denied.html
Often the problem is related to the MySQL accounts that the server permits client programs to use when connecting. See Section 8.2, “Access Control and Account Management”, and Section 8.2.22, “Troubleshooting Problems Connecting to MySQL”.
https://dev.mysql.com/doc/refman/9.7/en/events-syntax.html
When a scheduled event is no longer wanted or needed, it can be deleted from the server by its definer using the DROP EVENT statement. MySQL provides several SQL statements for working with scheduled events: New events are defined using the CREATE ...
https://dev.mysql.com/doc/refman/9.7/en/faqs-information-schema.html
The MySQL implementation is more similar to those found in DB2 and SQL Server, which also support INFORMATION_SCHEMA as defined in the SQL standard. Where can I find documentation for the MySQL INFORMATION_SCHEMA database? A.7.2. Where can I find ...