Search Results
https://dev.mysql.com/doc/refman/8.4/en/diagnostics-area.html
SQL statements produce diagnostic information that populates the diagnostics area. Standard SQL has a diagnostics area stack, containing a diagnostics area for each nested execution context. Standard SQL also supports GET STACKED DIAGNOSTICS syntax ...
https://dev.mysql.com/doc/refman/8.4/en/drop-spatial-reference-system.html
To identify which column or columns use the SRID, use this query: SELECT * FROM INFORMATION_SCHEMA.ST_GEOMETRY_COLUMNS WHERE SRS_ID=4326; SRID values must be in the range of 32-bit unsigned integers, with these restrictions: SRID 0 is a valid SRID ... DROP SPATIAL REFERENCE SYSTEM [IF EXISTS] srid srid: 32-bit unsigned integer This statement removes a spatial reference system (SRS) definition from the data ...
https://dev.mysql.com/doc/refman/8.4/en/encrypted-connections.html
With an unencrypted connection between the MySQL client and the server, someone with access to the network could watch all your traffic and inspect the data being sent or received between client and server. When you must move information over a ...
https://dev.mysql.com/doc/refman/8.4/en/enterprise-encryption-installation.html
To verify that the component has been installed, issue the statement shown here: SELECT * FROM mysql.component; Components listed in mysql.component are loaded by the loader service during the startup sequence. The functions are provided by a MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/error-log.html
For information about selecting the error message character set and language, see Section 12.6, “Error Message Character Set”, and Section 12.12, “Setting the Error Message Language”. This section discusses how to configure the MySQL server ...
https://dev.mysql.com/doc/refman/8.4/en/error-message-language.html
To select the language in which the server writes error messages, follow the instructions in this section. By default, mysqld produces error messages in English, but they can be displayed instead in any of several other languages: Czech, Danish, ...
https://dev.mysql.com/doc/refman/8.4/en/events-configuration.html
Although ON and OFF have numeric equivalents, the value displayed for event_scheduler by SELECT or SHOW VARIABLES is always one of OFF, ON, or DISABLED. Events are executed by a special event scheduler thread; when we refer to the Event Scheduler, ...
https://dev.mysql.com/doc/refman/8.4/en/events-metadata.html
Event times can be obtained by selecting from the Information Schema EVENTS table or from SHOW EVENTS, but they are reported as ETZ or STZ values. To obtain metadata about events: Query the EVENTS table of the INFORMATION_SCHEMA database. Event ...
https://dev.mysql.com/doc/refman/8.4/en/events-status-info.html
The Event Scheduler writes information about event execution that terminates with an error or warning to the MySQL Server's error log. See Section 27.4.6, “The Event Scheduler and MySQL Privileges” for an example. For frequently executed ...
https://dev.mysql.com/doc/refman/8.4/en/example-maximum-column-group.html
SELECT article, MAX(price) AS price FROM shop GROUP BY article ORDER BY article; +---------+-------+ | article | price | +---------+-------+ | 0001 | 3.99 | | 0002 | 10.99 | | 0003 | 1.69 | | 0004 | 19.95 | +---------+-------+ .