PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.3Kb
Man Pages (Zip)
- 401.7Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/user-resources.html
The server stores resource limits for an account in the user table row corresponding to the account. The max_questions, max_updates, and max_connections columns store the per-hour limits, and the max_user_connections column stores the ... One means ...
https://dev.mysql.com/doc/refman/8.0/en/window-function-descriptions.html
This section describes nonaggregate window functions that, for each row from a query, perform a calculation using rows related to that row. Most aggregate functions also can be used as window functions; see Section 14.19.1, “Aggregate Function ...
https://dev.mysql.com/doc/refman/8.0/en/aggregate-functions.html
For example: mysql> SELECT COUNT(*) FROM student; This optimization only applies to MyISAM tables, because an exact row count is stored for this storage engine and can be accessed very quickly. This section describes aggregate functions that ...
https://dev.mysql.com/doc/refman/8.0/en/alter-event.html
You cannot use stored routines or loadable functions in such expressions, and you cannot use any table references; however, you can use SELECT FROM DUAL. References to stored routines, loadable functions, and tables in such cases are specifically ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-partition-operations.html
Any data that was stored in the dropped partitions named in the partition_names list is discarded. The Transportable Tablespace feature makes it easy to copy the tablespaces from a running MySQL server instance to another running instance, or to ...
https://dev.mysql.com/doc/refman/8.0/en/assigning-passwords.html
MySQL stores credentials in the user table in the mysql system database. Required credentials for clients that connect to the MySQL server can include a password. Operations that assign or modify passwords are permitted only to users with the ...
https://dev.mysql.com/doc/refman/8.0/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. Causes the user variable on the left hand side of the ...
https://dev.mysql.com/doc/refman/8.0/en/atomic-ddl.html
In earlier MySQL versions, metadata was stored in metadata files, nontransactional tables, and storage engine-specific dictionaries, which necessitated intermediate commits. Supported non-table DDL statements include: CREATE and DROP statements, ...
https://dev.mysql.com/doc/refman/8.0/en/binlog-replication-configuration-overview.html
The information in the binary log is stored in different logging formats according to the database changes being recorded. The details are stored within the replica's connection metadata repository (see Section 19.2.4, “Relay Log and Replication ... This section describes replication between MySQL servers based on the binary log file position method, where the MySQL instance operating as the source (where the database changes take place) writes updates and changes as “events” to the binary ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-conversion.html
For a supplementary character, utf8mb4 requires four bytes to store it, whereas utf8mb3 cannot store the character at all. This section describes issues that you may face when converting character data between the utf8mb3 and utf8mb4 character sets. Note This discussion focuses primarily on converting between utf8mb3 and utf8mb4, but similar principles apply to converting between the ucs2 character set and character sets such as utf16 or ...