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/group-replication-functions.html
The functions described in the following sections are used with Group Replication.
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-transaction-summary-tables.html
The transaction access mode specifies whether transactions operate in read/write or read-only mode. The transaction access mode specifies whether transactions operate in read/write or read-only mode. Transaction Aggregation Rules Transaction event ... The Performance Schema maintains tables for collecting current and recent transaction events, and aggregates that information in summary ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-examples.html
In strict mode, inserting a value that is out of range for a column causes an error, rather than truncation to a legal value. This section provides some examples that show precision math query results in MySQL. These examples demonstrate the ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-installation.html
To ensure that your tables are up to date for upgrades from earlier versions of MySQL 8.0, perform the MySQL upgrade procedure, making sure to use the option that forces an update (see Chapter 3, Upgrading MySQL). If you prefer to run the update ...
https://dev.mysql.com/doc/refman/8.0/en/create-event.html
This is an example of a minimal CREATE EVENT statement: CREATE EVENT myevent ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 HOUR DO UPDATE myschema.mytable SET mycol = mycol + 1; The previous statement creates an event named myevent. CREATE [DEFINER ...
https://dev.mysql.com/doc/refman/8.0/en/extensions-to-ansi.html
If the ANSI_QUOTES SQL mode is enabled, strings can be enclosed only by ' and the server interprets strings enclosed by " as identifiers. The ORDER BY and LIMIT clauses of the UPDATE and DELETE statements. The LOW_PRIORITY clause of the INSERT, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-logging.html
The mysql client can do these types of logging for statements executed interactively: On Unix, mysql writes the statements to a history file. By default, this file is named .mysql_history in your home directory. To specify a different file, set the ...
https://dev.mysql.com/doc/refman/8.0/en/constraint-enum.html
Errors for invalid values can be suppressed in strict mode if you use INSERT IGNORE or UPDATE IGNORE. Unless strict mode is disabled (not recommended, but see Section 7.1.11, “Server SQL Modes”), the definition of a ENUM or SET column acts as a ... ENUM and SET columns provide an efficient way to define columns that can contain only a given set of ...
https://dev.mysql.com/doc/refman/8.0/en/example-auto-increment.html
You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is enabled. How AUTO_INCREMENT behaves depending on the NO_AUTO_VALUE_ON_ZERO SQL mode: Section 7.1.11, “Server SQL Modes”.
https://dev.mysql.com/doc/refman/8.0/en/fulltext-restrictions.html
Although FULLTEXT indexes on ucs2 columns cannot be used, you can perform IN BOOLEAN MODE searches on a ucs2 column that has no such index. The MATCH() column list must match exactly the column list in some FULLTEXT index definition for the table, ... Full-text searches are supported for InnoDB and MyISAM tables ...