PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/declare-handler.html
HANDLER statement had not been present, MySQL would have taken the default action (EXIT) after the second INSERT failed due to the PRIMARY KEY constraint, and SELECT @x would have returned 2. statement handler_action: { CONTINUE | EXIT | UNDO } ...
https://dev.mysql.com/doc/refman/8.0/en/default-privileges.html
This section describes how to assign a password to the initial root account created during the MySQL installation procedure, if you have not already done so. The initial root account may or may not have a password. The MySQL installation process ...
https://dev.mysql.com/doc/refman/8.0/en/descending-indexes.html
Indexes that have descending key parts are not used for MIN()/MAX() optimization of queries that invoke aggregate functions but do not have a GROUP BY clause. MySQL supports descending indexes: DESC in an index definition is no longer ignored but ...
https://dev.mysql.com/doc/refman/8.0/en/diagnostics-area.html
The statement information part of the diagnostics area contains these items: NUMBER: An integer indicating the number of condition areas that have information. Changes to the value of max_error_count have no effect until the next attempt to modify ... SQL statements produce diagnostic information that populates the diagnostics ...
https://dev.mysql.com/doc/refman/8.0/en/drop-index.html
This is done automatically by the server whenever it determines that it is possible to do so; you do not have to use any special SQL syntax or server options to cause it to happen. They have the same meaning as for the ALTER TABLE statement.
https://dev.mysql.com/doc/refman/8.0/en/drop-procedure.html
(DROP FUNCTION is also used to drop loadable functions; see Section 15.7.4.2, “DROP FUNCTION Statement for Loadable Functions”.) To drop a stored routine, you must have the ALTER ROUTINE privilege for it. See Section 27.2.2, “Stored Routines ... DROP {PROCEDURE | FUNCTION} [IF EXISTS] sp_name These statements are used to drop a stored routine (a stored procedure or ...
https://dev.mysql.com/doc/refman/8.0/en/drop-user.html
To use DROP USER, you must have the global CREATE USER privilege, or the DELETE privilege for the mysql system schema. (That is, the statement fails if dropping an account would cause a stored object to become orphaned.) To perform the operation ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-installation.html
When you have installed the component, if you want the component functions to support decryption and verification for content produced by the legacy functions before MySQL 8.0.30, set the component’s system variable ... In releases before MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/enum.html
For example, a column specified as ENUM('Mercury', 'Venus', 'Earth') can have any of the values shown here. Value Index NULL NULL '' 0 'Mercury' 1 'Venus' 2 'Earth' 3 An ENUM column can have a maximum of 65,535 distinct elements. An ENUM is a ...
https://dev.mysql.com/doc/refman/8.0/en/environment-variables.html
The UMASK and UMASK_DIR variables, despite their names, are used as modes, not masks: If UMASK is set, mysqld uses ($UMASK | 0600) as the mode for file creation, so that newly created files have a mode in the range from 0600 to 0666 (all values ...