Search Results
https://dev.mysql.com/doc/refman/8.4/en/do.html
In most respects, DO is shorthand for SELECT expr, ..., but has the advantage that it is slightly faster when you do not care about the result. DO is useful primarily with functions that have side effects, such as RELEASE_LOCK(). It cannot be used ...
https://dev.mysql.com/doc/refman/8.4/en/drop-index.html
For more information, see Section 15.1.9, “ALTER TABLE Statement” MySQL NDB Cluster supports online operations using the same ALGORITHM=INPLACE syntax supported in the standard MySQL Server. algorithm_option: ALGORITHM [=] {DEFAULT | INPLACE | ...
https://dev.mysql.com/doc/refman/8.4/en/drop-procedure.html
See Section 27.2.2, “Stored Routines and MySQL Privileges”.) In addition, if the definer of the routine has the SYSTEM_USER privilege, the user dropping it must also have this privilege. DROP {PROCEDURE | FUNCTION} [IF EXISTS] sp_name These ...
https://dev.mysql.com/doc/refman/8.4/en/drop-user.html
The DROP USER statement removes one or more MySQL accounts and their privileges. To use DROP USER, you must have the global CREATE USER privilege, or the DELETE privilege for the mysql system schema. It removes privilege rows for the account from ...
https://dev.mysql.com/doc/refman/8.4/en/error-access-denied.html
Often the problem is related to the MySQL accounts that the server permits client programs to use when connecting. See Section 8.2, “Access Control and Account Management”, and Section 8.2.22, “Troubleshooting Problems Connecting to MySQL”.
https://dev.mysql.com/doc/refman/8.4/en/estimating-performance.html
In MySQL, an index block is usually 1,024 bytes and the data pointer is usually four bytes. As long as everything is cached by the OS or the MySQL server, things become only marginally slower as the table gets bigger. In most cases, you can ...
https://dev.mysql.com/doc/refman/8.4/en/events-syntax.html
MySQL provides several SQL statements for working with scheduled events: New events are defined using the CREATE EVENT statement. The definition of an existing event can be changed by means of the ALTER EVENT statement. When a scheduled event is no ...
https://dev.mysql.com/doc/refman/8.4/en/explain-extended.html
Here is an example of extended EXPLAIN output: mysql> EXPLAIN SELECT t1.a, t1.a IN (SELECT t2.a FROM t2) FROM t1\G *************************** 1. row *************************** id: 2 select_type: SUBQUERY table: t2 type: index possible_keys: a key: ... The EXPLAIN statement produces extra (“extended”) information that is not part of EXPLAIN output but can be viewed by issuing a SHOW WARNINGS statement following ...
https://dev.mysql.com/doc/refman/8.4/en/flow-control-statements.html
MySQL supports the IF, CASE, ITERATE, LEAVE LOOP, WHILE, and REPEAT constructs for flow control within stored programs. Many of these constructs contain other statements, as indicated by the grammar specifications in the following sections. For ...
https://dev.mysql.com/doc/refman/8.4/en/full-table.html
The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. If a table-full error occurs, it may be that the disk is full or that the table has reached its ...