MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 191 to 199 of 199 total results

« Previous
18
19
20
Next »

https://dev.mysql.com/doc/refman/8.0/en/performance-schema-quick-start.html

This section briefly introduces the Performance Schema with examples that show how to use it. For additional examples, see Section 29.19, “Using the Performance Schema to Diagnose Problems”. To enable or disable it explicitly, start the server ...

9.5.2 Point-in-Time Recovery Using Event Positions

https://dev.mysql.com/doc/refman/8.0/en/point-in-time-recovery-positions.html

The last section, Section 9.5.1, “Point-in-Time Recovery Using Binary Log”, explains the general idea of using the binary log to perform a point-in-time-recovery. As an example, suppose that around 20:06:00 on March 11, 2020, an SQL statement ...

15.7.7.7 SHOW CREATE EVENT Statement

https://dev.mysql.com/doc/refman/8.0/en/show-create-event.html

SHOW CREATE EVENT event_name This statement displays the CREATE EVENT statement needed to re-create a given event. It requires the EVENT privilege for the database from which the event is to be shown. For example (using the same event e_daily ...

15.7.7.11 SHOW CREATE TRIGGER Statement

https://dev.mysql.com/doc/refman/8.0/en/show-create-trigger.html

SHOW CREATE TRIGGER trigger_name This statement shows the CREATE TRIGGER statement that creates the named trigger. This statement requires the TRIGGER privilege for the table associated with the trigger. row *************************** Trigger: ...

15.7.7.13 SHOW CREATE VIEW Statement

https://dev.mysql.com/doc/refman/8.0/en/show-create-view.html

SHOW CREATE VIEW view_name This statement shows the CREATE VIEW statement that creates the named view. row *************************** View: v Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`bob`@`localhost` SQL SECURITY DEFINER VIEW `v` AS select ...

15.7.7.18 SHOW EVENTS Statement

https://dev.mysql.com/doc/refman/8.0/en/show-events.html

SHOW EVENTS [{FROM | IN} schema_name] [LIKE 'pattern' | WHERE expr] This statement displays information about Event Manager events, which are discussed in Section 27.4, “Using the Event Scheduler”. It requires the EVENT privilege for the ...

15.7.7.40 SHOW TRIGGERS Statement

https://dev.mysql.com/doc/refman/8.0/en/show-triggers.html

SHOW TRIGGERS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TRIGGERS lists the triggers currently defined for tables in a database (the default database unless a FROM clause is given). This statement returns results only for databases ...

27.7 Stored Program Binary Logging

https://dev.mysql.com/doc/refman/8.0/en/stored-programs-logging.html

The binary log contains information about SQL statements that modify database contents. This information is stored in the form of “events” that describe the modifications. (Binary log events differ from scheduled event stored objects.) The ...

11.4 User-Defined Variables

https://dev.mysql.com/doc/refman/8.0/en/user-variables.html

You can store a value in a user-defined variable in one statement and refer to it later in another statement. This enables you to pass values from one statement to another. User variables are written as @var_name, where the variable name var_name ...