https://dev.mysql.com/thread-information.html
Time indicates how long the thread has been in its current state. The thread's notion of the current time may be altered in some cases: The thread can change the time with SET TIMESTAMP = value. For a thread running on a slave that is processing ...
https://dev.mysql.com/trigger-syntax.html
It also includes clauses that specify the trigger action time, the triggering event, and what to do when the trigger activates: The keyword BEFORE indicates the trigger action time. The statement following FOR EACH ROW defines the trigger body; that ... To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 13.1.22, “CREATE TRIGGER Statement”, and Section 13.1.34, “DROP TRIGGER ...
https://dev.mysql.com/with.html
A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be referred to later within that statement, possibly multiple times. As a development technique to guard against a ...
https://dev.mysql.com/binary-log.html
The number increases each time the server creates a new log file, thus creating an ordered series of files. The server creates a new file in the series each time it starts or flushes the logs. For more information about the binary log and recovery ... The binary log contains “events” that describe database changes such as table creation operations or changes to table ...
https://dev.mysql.com/bug-reports.html
Writing a good bug report takes patience, but doing it right the first time saves time both for us and for yourself. This section helps you write your report correctly so that you do not waste your time doing things that may not help us much or at ... Before posting a bug report about a problem, please try to verify that it is a bug and that it has not been reported already: Start by searching the MySQL online manual at ...
https://dev.mysql.com/c-api-prepared-statement-data-structures.html
The MYSQL_TIME structure is used to transfer temporal data in both directions. For date and time data types, buffer should point to a MYSQL_TIME structure. MYSQL_TIME This structure is used to send and receive DATE, TIME, DATETIME, and TIMESTAMP ...
https://dev.mysql.com/charset-connection.html
These session system variable values are initialized at connect time, but can be changed within the session. With the mysql client, to use a character set different from the default, you could explicitly execute a SET NAMES statement every time you ... A “connection” is what a client program makes when it connects to the server, to begin a session within which it interacts with the ...
https://dev.mysql.com/controlling-query-plan-evaluation.html
However, when larger queries are submitted, the time spent in query optimization may easily become the major bottleneck in the server's performance. The general idea is that the fewer plans that are investigated by the optimizer, the less time it ...
https://dev.mysql.com/create-procedure.html
The DEFINER and SQL SECURITY clauses specify the security context to be used when checking access privileges at routine execution time, as described later in this section. For statements that can be determined at function definition time to return a ...To associate the routine explicitly with a given database, specify the name as db_name.sp_name when you create ...
https://dev.mysql.com/faqs-triggers.html
Can a table have multiple triggers with the same trigger event and action time? A.5.11. MySQL does have specific special behavior for some TIMESTAMP columns, as well as for columns which are defined using AUTO_INCREMENT. Can a table have multiple ...
