Search Results
https://dev.mysql.com/doc/refman/9.7/en/create-event.html
IF NOT EXISTS has the same meaning for CREATE EVENT as for CREATE TABLE: If an event named event_name already exists in the same schema, no action is taken, and no error results. CREATE EVENT statements which are themselves invalid—for whatever ...
https://dev.mysql.com/doc/refman/9.7/en/create-procedure.html
If the routine name is the same as the name of a built-in SQL function, a syntax error occurs unless you use a space between the name and the following parenthesis when defining the routine or invoking it later. IF NOT EXISTS prevents an error from ...By default, a stored routine is associated with the default ...
https://dev.mysql.com/doc/refman/9.7/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 dictionary, and requires the CREATE_SPATIAL_REFERENCE_SYSTEM privilege (or ...
https://dev.mysql.com/doc/refman/9.7/en/create-view.html
If the view already exists and IF NOT EXISTS is specified, the statement is succeeds with a warning rather than an error; in this case, the view definition is not changed. Attempting to do so causes the statement to be rejected with a syntax error.
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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, ...