Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-spatial-reference-system.html
SRID values must be unique, so if neither OR REPLACE nor IF NOT EXISTS is specified, an error occurs if an SRS definition with the given srid value already exists. For example: mysql> CREATE OR REPLACE SPATIAL REFERENCE SYSTEM 4326 ...; ERROR 3716 ...srs_attribute: { NAME 'srs_name' | DEFINITION 'definition' | ORGANIZATION 'org_name' IDENTIFIED BY org_id | DESCRIPTION 'description' } srid, org_id: 32-bit unsigned integer This statement creates a spatial reference system (SRS) definition and stores it in the data ...
https://dev.mysql.com/doc/refman/8.4/en/encryption-functions.html
The error message includes the parse error only if the statement is provided as a literal string. If you want to store these results, use a column with a VARBINARY or BLOB binary string data type. This avoids potential problems with trailing space ...
https://dev.mysql.com/doc/refman/8.4/en/explain.html
You should be aware that while this makes the output easier to read, it also renders the JSON invalid, causing JSON functions to raise an error. row *************************** EXPLAIN: -> Filter: (t.c2 > 50) (cost=0.35 rows=1) -> Covering index ...
https://dev.mysql.com/doc/refman/8.4/en/file-permissions.html
For example, mysqld might issue the following error message when you create a table: ERROR: Can't find file: 'path/with/file_name' (Errcode: 13) The default UMASK and UMASK_DIR values are 0640 and 0750, respectively. If this is unsuitable, create ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-reference.html
For example, if mysql is the firewall database: CALL mysql.sp_set_firewall_group_mode(group, mode); In MySQL 8.4, firewall stored procedures are transactional; if an error occurs during execution of a firewall stored procedure, all changes made by ...When enabled, the firewall bases operational decisions on the cached ...
https://dev.mysql.com/doc/refman/8.4/en/gis-wkt-functions.html
If the options argument is invalid, an error occurs to indicate why. If an SRID argument refers to an undefined spatial reference system (SRS), an ER_SRS_NOT_FOUND error occurs. For geographic SRS geometry arguments, if any argument has a longitude ... These functions take as arguments a Well-Known Text (WKT) representation and, optionally, a spatial reference system identifier ...
https://dev.mysql.com/doc/refman/8.4/en/information-functions.html
Beyond the cases described here, the behavior of FOUND_ROWS() is undefined (for example, its value following a SELECT statement that fails with an error). (You should be aware that, if you mix references to LAST_INSERT_ID() and LAST_INSERT_ID(expr), ...It may be used to time how quickly MySQL processes the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-internals.html
If the row does not fit, the following error message is issued: ERROR HY000: Too big row. If you create a table when innodb_strict_mode is OFF, and a subsequent INSERT or UPDATE statement attempts to create an index entry that does not fit in the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-enabling-monitors.html
When InnoDB monitors are enabled for periodic output, InnoDB writes the output to mysqld server standard error output (stderr) every 15 seconds, approximately. If you want to direct the output to the console window rather than to the error log, ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-standard-monitor.html
This limit does not apply to output written to server standard error output (stderr). LATEST FOREIGN KEY ERROR This section provides information about the most recent foreign key constraint error. The Lock Monitor is the same as the Standard ...