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/performance-schema-object-filtering.html
The setup_objects table controls whether the Performance Schema monitors particular table and stored program objects. The OBJECT_TYPE column indicates the type of object to which a row applies. TABLE filtering affects table I/O events ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-transaction-tables.html
Triggers Triggers activate as part of a statement that accesses the table with which it is associated, so the parent of a trigger event is always the statement that activates it. Triggers cannot issue statements that cause an explicit or implicit ...
https://dev.mysql.com/doc/refman/8.0/en/stored-objects.html
Trigger: An object created with CREATE TRIGGER that is associated with a table. A trigger is activated when a particular event occurs for the table, such as an insert or update. This chapter discusses stored database objects that are defined in ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.
https://dev.mysql.com/doc/refman/8.0/en/account-activity-auditing.html
Applications can use the following guidelines to perform SQL-based auditing that ties database activity to MySQL accounts. When a client connects successfully, the server authenticates the client to a particular row in this table. The User and Host ...
https://dev.mysql.com/doc/refman/8.0/en/blackhole-storage-engine.html
However, because the BLACKHOLE table does not actually store any data, UPDATE and DELETE triggers are not activated: The FOR EACH ROW clause in the trigger definition does not apply because there are no rows. The BLACKHOLE storage engine acts as a ...
https://dev.mysql.com/doc/refman/8.0/en/bug-reports.html
For stored procedure, stored function, and trigger objects, the relevant sql_mode value is the one in effect when the object was created. Before posting a bug report about a problem, please try to verify that it is a bug and that it has not been ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-stored-procs.html
Can a stored procedure call a trigger? A stored procedure can execute an SQL statement, such as an UPDATE, that causes a trigger to activate. Where can I find documentation for MySQL stored procedures and stored functions? A.4.3. Where can I find ...
https://dev.mysql.com/doc/refman/8.0/en/glossary.html
For example, an employee leaving a company might trigger a sequence of actions from the human resources department. stored program A stored routine (procedure or function), trigger, or Event Scheduler event. Column values are not stored, but are ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-qualifiers.html
An unqualified name is permitted in contexts where interpretation of the name is unambiguous. A qualified name includes at least one qualifier to clarify the interpretive context by overriding a default context or providing missing context. For ...