Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-features-row-searches.html
If there are suitable indexes, one index is selected from the candidates, in the following priority order: A primary key. If the algorithm is able to select a primary key or a unique index where every column in the index has a NOT NULL attribute, it ... When a replica using row-based replication format applies an UPDATE or DELETE operation, it must search the relevant table for the matching ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-gtids.html
SELECT statements are supported for storage engines that support atomic DDL. Using SELECT @@ENFORCE_GTID_CONSISTENCY, SHOW VARIABLES LIKE 'ENFORCE_GTID_CONSISTENCY', and SELECT * FROM INFORMATION_SCHEMA.VARIABLES WHERE 'VARIABLE_NAME' = ... The ...
https://dev.mysql.com/doc/refman/8.4/en/resetting-permissions.html
For a server that is running as a Windows service, go to the Services manager: From the Start menu, select Control Panel, then Administrative Tools, then Services. Open a console window to get to the command prompt: From the Start menu, select Run, ... If you have never assigned a root password for MySQL, the server does not require a password at all for connecting as ...
https://dev.mysql.com/doc/refman/8.4/en/show-errors.html
The LIMIT clause has the same syntax as for the SELECT statement. You can also retrieve this number from the error_count variable: SHOW COUNT(*) ERRORS; SELECT @@error_count; SHOW ERRORS and error_count apply only to errors, not warnings or notes.
https://dev.mysql.com/doc/refman/8.4/en/show-processlist.html
db The default database for the thread, or NULL if none has been selected. For example, if a CALL statement executes a stored procedure that is executing a SELECT statement, the Info value shows the SELECT statement. SHOW [FULL] PROCESSLIST ...
https://dev.mysql.com/doc/refman/8.4/en/show-table-status.html
The WHERE clause can be given to select rows using more general conditions, as discussed in Section 28.8, “Extensions to SHOW Statements”. In such cases, use SELECT COUNT(*) to obtain an accurate count. A more accurate method of obtaining this ... SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works like SHOW TABLES, but provides a lot of information about each non-TEMPORARY ...
https://dev.mysql.com/doc/refman/8.4/en/show-variables.html
A WHERE clause can be given to select rows using more general conditions, as discussed in Section 28.8, “Extensions to SHOW Statements”. For variables with very long values that are not completely displayed, use SELECT as a workaround. For ...
https://dev.mysql.com/doc/refman/8.4/en/sorting-rows.html
You may have noticed in the preceding examples that the result rows are displayed in no particular order. It is often easier to examine query output when the rows are sorted in some meaningful way. This means that the order is undefined for columns ...
https://dev.mysql.com/doc/refman/8.4/en/source-configuration-options.html
-DINSTALL_LAYOUT=name Select a predefined installation layout: STANDALONE: Same layout as used for .tar.gz and .zip packages. You can select a predefined layout but modify individual component installation locations by specifying other options. The ...
https://dev.mysql.com/doc/refman/8.4/en/string-functions-charset.html
MySQL has many operators and functions that return a string. This section answers the question: What is the character set and collation of such a string? For simple functions that take string input and return a string result as output, the output's ...