PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/optimizer-hints.html
The parser recognizes optimizer hint comments after the initial keyword of SELECT, UPDATE, INSERT, REPLACE, and DELETE statements. One means of control over optimizer strategies is to set the optimizer_switch system variable (see Section 8.9.2, ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-subqueries.html
For example: SELECT * FROM t1 WHERE t1.column1 IN (SELECT column1 FROM t2 ORDER BY column1); SELECT * FROM t1 WHERE t1.column1 IN (SELECT DISTINCT column1 FROM t2); SELECT * FROM t1 WHERE EXISTS (SELECT * FROM t2 LIMIT 1); Replace a join with a ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-auto-positioning.html
GTIDs replace the file-offset pairs previously required to determine points for starting, stopping, or resuming the flow of data between source and replica. The correct approach to recover from this situation is for the replica to replicate the ...
https://dev.mysql.com/doc/refman/5.7/en/shared-key-cache.html
Multiple sessions can initiate requests that result in cache block replacements, as long as they do not interfere with each other (that is, as long as they need different index blocks, and thus cause different cache blocks to be replaced). Threads ...
https://dev.mysql.com/doc/refman/5.7/en/string-functions-charset.html
The same applies for INSTR(), LCASE(), LOWER(), LTRIM(), MID(), REPEAT(), REPLACE(), REVERSE(), RIGHT(), RPAD(), RTRIM(), SOUNDEX(), SUBSTRING(), TRIM(), UCASE(), and UPPER(). Note The REPLACE() function, unlike all other functions, always ignores ... MySQL has many operators and functions that return a ...
https://dev.mysql.com/doc/refman/5.7/en/sys-format-path.html
Given a path name, returns the modified path name after replacing subpaths that match the values of the following system variables, in order: datadir tmpdir slave_load_tmpdir innodb_data_home_dir innodb_log_group_home_dir innodb_undo_directory ...
https://dev.mysql.com/doc/refman/5.7/en/traceable-statements.html
Statements which are traceable are listed here: SELECT INSERT REPLACE UPDATE DELETE EXPLAIN with any of the preceding statements SET DO DECLARE, CASE, IF, and RETURN as used in stored routines CALL Tracing is supported for both INSERT and REPLACE ...For statements which are prepared and executed in separate steps, preparation and execution are traced ...
https://dev.mysql.com/doc/refman/5.7/en/account-management-statements.html
MySQL account information is stored in the tables of the mysql system database. This database and the access control system are discussed extensively in Chapter 5, MySQL Server Administration, which you should consult for additional details. This ...Important Some MySQL releases introduce changes to the grant tables to add new privileges or ...
https://dev.mysql.com/doc/refman/5.7/en/account-names.html
MySQL stores account names in grant tables in the mysql system database using separate columns for the user name and host name parts: The user table contains one row for each account. Other grant tables indicate privileges an account has for ...
https://dev.mysql.com/doc/refman/5.7/en/alter-event.html
(See Section 13.1.12, “CREATE EVENT Statement”.) Any user can alter an event defined on a database for which that user has the EVENT privilege. This statement renames the event myevent to yourevent: ALTER EVENT myevent RENAME TO yourevent; You ... ALTER [DEFINER = user] EVENT event_name [ON SCHEDULE schedule] [ON COMPLETION [NOT] PRESERVE] [RENAME TO new_event_name] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] [DO event_body] The ALTER EVENT statement changes one or more of the characteristics of an existing event without the need to drop and recreate ...