Search Results
https://dev.mysql.com/doc/refman/9.7/en/drop-resource-group.html
The FORCE modifier determines statement behavior if the resource group has any threads assigned to it: If FORCE is not given and any threads are assigned to the group, an error occurs. DROP RESOURCE GROUP group_name [FORCE] DROP RESOURCE GROUP is ...
https://dev.mysql.com/doc/refman/9.7/en/drop-table.html
If any tables named in the argument list do not exist, DROP TABLE behavior depends on whether the IF EXISTS clause is given: Without IF EXISTS, the statement fails with an error indicating which nonexisting tables it was unable to drop, and no ...Be ...
https://dev.mysql.com/doc/refman/9.7/en/drop-view.html
If any views named in the argument list do not exist, the statement fails with an error indicating by name which nonexisting views it was unable to drop, and no changes are made. The IF EXISTS clause prevents an error from occurring for views that ...DROP VIEW works with SQL views (see Section 27.6, “Using Views”) as well as with JSON duality views (see Section 27.7, “JSON Duality ...
https://dev.mysql.com/doc/refman/9.7/en/explain-for-connection.html
If the named connection is executing a statement that is not explainable, an error occurs. To obtain the execution plan for an explainable statement executing in a named connection, use this statement: EXPLAIN [options] FOR CONNECTION ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/features.html
Localization The server can provide error messages to clients in many languages. This section describes some of the important characteristics of the MySQL Database Software. In most respects, the roadmap applies to all versions of MySQL. Tested ...
https://dev.mysql.com/doc/refman/9.7/en/federated-usagenotes.html
ON DUPLICATE KEY UPDATE statements, but if a duplicate-key violation occurs, the statement fails with an error. Also, if the remote table is transactional, it enables the remote storage engine to perform statement rollback properly should an error ...The following items indicate features that the FEDERATED storage engine does and does not support: The remote server must be a MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/full-disk.html
This section describes how MySQL responds to disk-full errors (such as “no space left on device”), and to quota-exceeded errors (such as “write failed” or “user block limit reached”). If there is enough space, it continues as if nothing ...
https://dev.mysql.com/doc/refman/9.7/en/geometry-well-formedness-validity.html
Spatial import functions that parse WKT or WKB values raise an error for attempts to create a geometry that is not syntactically well-formed. Spatial computations may detect some cases of invalid geometries and raise an error, but they may also ...
https://dev.mysql.com/doc/refman/9.7/en/gis-format-conversion-functions.html
If any geometry argument is not a syntactically well-formed geometry, an ER_GIS_INVALID_DATA error occurs. If the options argument is invalid, an error occurs to indicate why. MySQL supports the functions listed in this section for converting ...