Search Results
https://dev.mysql.com/doc/refman/8.4/en/creating-accounts.html
To manage MySQL accounts, use the SQL statements intended for that purpose: CREATE USER and DROP USER create and remove accounts. To update the tables to the expected structure, perform the MySQL upgrade procedure. Another option for creating ...
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. MySQL provides several functions for extracting parts of dates, such as YEAR(), MONTH(), and DAYOFMONTH().
https://dev.mysql.com/doc/refman/8.4/en/error-log-configuration.html
In MySQL 8.4, error logging uses the MySQL component architecture described at Section 7.5, “MySQL Components”. By default, log_error_services has the value shown here: mysql> SELECT @@GLOBAL.log_error_services; ...The error log subsystem ...
https://dev.mysql.com/doc/refman/8.4/en/error-message-elements.html
This section discusses how error messages originate within MySQL and the elements they contain. The MySQL server writes some error messages to its error log. The MySQL client library takes errors received from the server and makes them available to ...These indicate issues of interest to database administrators or that require DBA ...
https://dev.mysql.com/doc/refman/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/get-diagnostics.html
It is a MySQL extension that GET [CURRENT] DIAGNOSTICS is permitted outside handler context to check the execution of any SQL statement. For a description of the diagnostics area, see Section 15.6.7.7, “The MySQL Diagnostics Area”. When a ...
https://dev.mysql.com/doc/refman/8.4/en/gis-data-formats.html
Two standard spatial data formats are used to represent geometry objects in queries: Well-Known Text (WKT) format Well-Known Binary (WKB) format Internally, MySQL stores geometry values in a format that is not identical to either WKT or WKB format.
https://dev.mysql.com/doc/refman/8.4/en/group-replication-bootstrap.html
mysql> CREATE DATABASE test; mysql> USE test; mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 TEXT NOT NULL); mysql> INSERT INTO t1 VALUES (1, 'Luis'); Check the content of table t1 and the binary log. The process of starting a group for the first ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-use-cases.html
To summarize, MySQL Group Replication guarantees that the database service is continuously available. To summarize, MySQL Group Replication provides a highly available, highly elastic, dependable MySQL service. Tip To deploy multiple instances of ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication.html
This chapter explains Group Replication in MySQL 8.4, and how to install, configure and monitor groups. MySQL Group Replication enables you to create elastic, highly-available, fault-tolerant replication topologies. An alternative way to deploy a ...Groups can operate in a single-primary mode with automatic primary election, where only one server accepts updates at a ...