Search Results
https://dev.mysql.com/doc/refman/8.4/en/assignment-operators.html
Table 14.6 Assignment Operators Name Description := Assign a value = Assign a value (as part of a SET statement, or as part of the SET clause in an UPDATE statement) := Assignment operator. This means you can use := in any valid SQL statement (not ...Causes the user variable on the left hand side of the operator to take on the value to its ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-formats.html
The server uses several logging formats to record information in the binary log: Replication capabilities in MySQL originally were based on propagation of SQL statements from source to replica. You can cause this format to be used by starting the ...In row-based logging (the default), the source writes events to the binary log that indicate how individual table rows are ...
https://dev.mysql.com/doc/refman/8.4/en/events-privileges.html
The same would be true if root had issued either of these statements: DROP USER jon@ghidora; RENAME USER jon@ghidora TO someotherguy@ghidora; You can verify that this is true by examining the Information Schema EVENTS table before and after issuing ... To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-stored-procs.html
Do stored procedures have a statement for raising application errors? A.4.13. 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. Do stored procedures have a ...Where can I find documentation for MySQL stored procedures and stored functions? ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-introduction.html
Although you can select INFORMATION_SCHEMA as the default database with a USE statement, you can only read the contents of tables, not perform INSERT, UPDATE, or DELETE operations on them. FROM INFORMATION_SCHEMA statement is intended as a more ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-obtaining-parent-events.html
For statements, it all depends on whether the statement that took a lock is a statement in a transaction that has already completed (use events_statements_history) or the statement is still running (use events_statements_current). For stages, the ...
https://dev.mysql.com/doc/refman/8.4/en/persisted-system-variables.html
Many system variables are dynamic and can be changed at runtime using the SET statement to affect operation of the current server instance. Examples: SET PERSIST max_connections = 1000; SET @@PERSIST.max_connections = 1000; SET PERSIST_ONLY back_log ... The MySQL server maintains system variables that configure its ...
https://dev.mysql.com/doc/refman/8.4/en/sys-processlist.html
They provide more complete information than the SHOW PROCESSLIST statement and the INFORMATION_SCHEMA PROCESSLIST table, and are also nonblocking. current_statement The statement the thread is executing, or NULL if it is not executing any statement.
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-8.html
Collection.dropIndex() now executes immediately and returns void; also the DropCollectionIndexStatement interface has been removed. (WL #10620) X DevAPI: To support row locks for the find() method of the X DevAPI, the FindStatement and the ...
https://dev.mysql.com/doc/mysql-em-plugin/en/ui-myoem-homepage-regions.html
The following regions are available: Availability History Configuration Summary Connections Transaction Activity Row Activity InnoDB Buffer Pool Usage (pages) Response Time (ms) Statement Activity Incidents and Problems Availability History The ...