PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/sys-list-add.html
Example mysql> SELECT @@sql_mode; +----------------------------------------+ | @@sql_mode | +----------------------------------------+ | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES | +----------------------------------------+ mysql> SET @@sql_mode = ...
https://dev.mysql.com/doc/refman/8.0/en/sys-version.html
This view provides the current sys schema and MySQL server versions. Note As of MySQL 8.0.18, this view is deprecated and subject to removal in a future MySQL version. For example, use the VERSION() function to retrieve the MySQL server version.
https://dev.mysql.com/doc/refman/8.0/en/table-size-limit.html
The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. Windows users, please note that FAT and VFAT (FAT32) are not considered suitable for production ...For up-to-date information operating system file size limits, refer to the documentation specific to your operating ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool-elements.html
Prior to MySQL 8.0.14, the monitoring tables are INFORMATION_SCHEMA tables; see Section 28.5, “INFORMATION_SCHEMA Thread Pool Tables”. The INFORMATION_SCHEMA tables now are deprecated; expect them to be removed in a future version of MySQL. To ...Applications should transition away from the INFORMATION_SCHEMA tables to the Performance Schema ...
https://dev.mysql.com/doc/refman/8.0/en/triggers.html
Important MySQL triggers activate only for changes made to tables by SQL statements. Triggers do not activate for changes to tables made by APIs that do not transmit SQL statements to the MySQL Server. Additional Resources You may find the MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/using-innodb-tables.html
However, the ENGINE clause is useful if the CREATE TABLE statement is to be replayed on a different MySQL Server instance where the default storage engine is not InnoDB or is unknown. You can determine the default storage engine on a MySQL Server ...
https://dev.mysql.com/doc/refman/8.0/en/view-algorithms.html
The optional ALGORITHM clause for CREATE VIEW or ALTER VIEW is a MySQL extension to standard SQL. In this case, MySQL generates a warning and sets the algorithm to UNDEFINED. For MERGE, the text of a statement that refers to the view and the view ...
https://dev.mysql.com/doc/refman/8.0/en/view-syntax.html
The CREATE VIEW statement creates a new view (see Section 15.1.23, “CREATE VIEW Statement”). To alter the definition of a view or drop a view, use ALTER VIEW (see Section 15.1.11, “ALTER VIEW Statement”), or DROP VIEW (see Section 15.1.35, ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-events-table.html
TIME_ZONE The event time zone, which is the time zone used for scheduling the event and that is in effect within the event as it executes. EVENT_TYPE The event repetition type, either ONE TIME (transient) or RECURRING (repeating). EXECUTE_AT For a ... The EVENTS table provides information about Event Manager events, which are discussed in Section 27.4, “Using the Event ...
https://dev.mysql.com/doc/refman/8.0/en/scheduler-component.html
Note The scheduler component is included in MySQL Enterprise Edition, a commercial product. As of MySQL 8.0.34, the scheduler component provides an implementation of the mysql_scheduler service that enables applications, components, or plugins to ...For example, the audit_log server plugin calls the scheduler component at its initialization and configures a regular, recurring flush of its memory cache (see Enabling the Audit Log Flush ...