PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/close.html
If not closed explicitly, a cursor is closed at the end of the BEGIN ...
https://dev.mysql.com/doc/refman/8.0/en/condition-handling-restrictions.html
In MySQL, this is not guaranteed, so to get the main error, you cannot do this: GET DIAGNOSTICS CONDITION 1 @errno = MYSQL_ERRNO; Instead, do this: GET DIAGNOSTICS @cno = NUMBER; GET DIAGNOSTICS CONDITION @cno @errno = MYSQL_ERRNO; . In standard ...
https://dev.mysql.com/doc/refman/8.0/en/condition-handling.html
Conditions may arise during stored program execution that require special handling, such as exiting the current program block or continuing execution. Handlers can be defined for general conditions such as warnings or exceptions, or for specific ...
https://dev.mysql.com/doc/refman/8.0/en/conditions-and-parameters.html
If the exception is an error, the values of OUT and INOUT parameters are not propagated back to the caller. If a stored procedure exits with an unhandled exception, modified values of OUT and INOUT parameters are not propagated back to the caller.
https://dev.mysql.com/doc/refman/8.0/en/creating-accounts.html
For any operation that modifies a grant table, the server checks whether the table has the expected structure and produces an error if not. The next example creates three accounts and grants them access at lower levels; that is, to specific ... To ...GRANT and REVOKE assign privileges to and revoke privileges from ...
https://dev.mysql.com/doc/refman/8.0/en/deallocate-prepare.html
{DEALLOCATE | DROP} PREPARE stmt_name To deallocate a prepared statement produced with PREPARE, use a DEALLOCATE PREPARE statement that refers to the prepared statement name. Attempting to execute a prepared statement after deallocating it results ...
https://dev.mysql.com/doc/refman/8.0/en/delete-optimization.html
Truncate operations are not transaction-safe; an error occurs when attempting one in the course of an active transaction or active table lock. The time required to delete individual rows in a MyISAM table is exactly proportional to the number of ...
https://dev.mysql.com/doc/refman/8.0/en/drop-trigger.html
If the schema is omitted, the trigger is dropped from the default schema. DROP TRIGGER requires the TRIGGER privilege for the table associated with the trigger. Use IF EXISTS to prevent an error from occurring for a trigger that does not exist.
https://dev.mysql.com/doc/refman/8.0/en/end-markers-in-json-system-variable.html
Note If end_markers_in_json is enabled, the repetition of the key means the result is not a valid JSON document, and causes JSON parsers to throw an error. When reading a very large JSON document, it can be difficult to pair its closing bracket and ...
https://dev.mysql.com/doc/refman/8.0/en/events-overview.html
Whereas a trigger is a database object whose statements are executed in response to a specific type of event that occurs on a given table, a (scheduled) event is an object whose statements are executed in response to the passage of a specified time ...When you create an event, you are creating a named database object containing one or more SQL statements to be executed at one or more regular intervals, beginning and ending at a specific date and ...