Search Results
https://dev.mysql.com/doc/refman/8.4/en/document-store-concepts.html
The most important differences between a document and the tables known from traditional relational databases are that the structure of a document does not have to be defined in advance, and a collection can contain multiple documents with different ... This section explains the concepts introduced as part of using MySQL as a document ...
https://dev.mysql.com/doc/refman/8.4/en/drop-database.html
Important When a database is dropped, privileges granted specifically for the database are not automatically dropped. DROP {DATABASE | SCHEMA} [IF EXISTS] db_name DROP DATABASE drops all tables in the database and deletes the database. Be very ...
https://dev.mysql.com/doc/refman/8.4/en/drop-logfile-group.html
(For information on creating log file groups, see Section 15.1.16, “CREATE LOGFILE GROUP Statement”.) Important Before dropping a log file group, you must drop all tablespaces that use that log file group for UNDO logging. DROP LOGFILE GROUP ...
https://dev.mysql.com/doc/refman/8.4/en/drop-table.html
Important When a table is dropped, privileges granted specifically for the table are not automatically dropped. Be careful with this statement! For each table, it removes the table definition and all table data. If the table is partitioned, the ...
https://dev.mysql.com/doc/refman/8.4/en/drop-user.html
Important DROP USER does not automatically close any open user sessions. The DROP USER statement removes one or more MySQL accounts and their privileges. It removes privilege rows for the account from all grant tables. Roles named in the ...
https://dev.mysql.com/doc/refman/8.4/en/error-log-syslog.html
MySQL uses the custom label “System” for important system messages about non-error situations, such as startup, shutdown, and some significant changes to settings. It is possible to have mysqld write the error log to the system log (the Event ...
https://dev.mysql.com/doc/refman/8.4/en/events-configuration.html
Events are executed by a special event scheduler thread; when we refer to the Event Scheduler, we actually refer to this thread. When running, the event scheduler thread and its current state can be seen by users having the PROCESS privilege in the ...
https://dev.mysql.com/doc/refman/8.4/en/explain.html
Important If, for any reason, the statement to be analyzed is rejected, the user variable is not updated. In practice, the DESCRIBE keyword is more often used to obtain information about table structure, whereas EXPLAIN is used to obtain a query ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-general.html
Why did MySQL version numbering skip versions 6 and 7 and go straight to 8.0? Due to the many new and important features we were introducing in this MySQL version, we decided to start a fresh new series. Why did MySQL version numbering skip versions ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-tablespace-encryption.html
In the health care industry, the privacy of patient data, health records and X-ray images is of the highest importance. Is data decrypted for users who are authorized to see it? A.17.2. What are the encryption algorithms used with InnoDB ...