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/values.html
Each ROW() in the same VALUES statement must have the same number of values in its value list. VALUES is a DML statement introduced in MySQL 8.0.19 which returns a set of one or more rows as a table. In other words, it is a table value constructor ...
https://dev.mysql.com/doc/refman/8.0/en/view-updatability.html
The view must contain all columns in the base table that do not have a default value. Some views are updatable and references to them can be used to specify tables to be updated in data change statements. That is, you can use them in statements ...
https://dev.mysql.com/doc/refman/8.0/en/windows-restrictions.html
Some versions of Windows have a boot time setting to enable larger applications by reducing the kernel application. Limited number of ports Windows systems have about 4,000 ports available for client connections, and after a connection on a port ...
https://dev.mysql.com/doc/refman/8.0/en/windows-server-first-start.html
Adjust the path names shown in the examples if you have MySQL installed in a different location. In this way you can have the server display status messages in the window where they are easy to see. This section gives a general overview of starting ...
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-connection-compression.html
Increases in the compression effort do not have a linear relationship to increases in the compression ratio. The default compression levels used by X Plugin from MySQL 8.0.20 have been selected through performance testing as being a good trade-off ... From MySQL 8.0.19, X Plugin supports compression of messages sent over X Protocol ...
https://dev.mysql.com/doc/refman/8.0/en/xa-statements.html
To perform XA transactions in MySQL, use the following statements: XA {START|BEGIN} xid [JOIN|RESUME] XA END xid [SUSPEND [FOR MIGRATE]] XA PREPARE xid XA COMMIT xid [ONE PHASE] XA ROLLBACK xid XA RECOVER [CONVERT XID] For XA START, the JOIN and ...
https://dev.mysql.com/doc/refman/8.0/en/account-locking.html
It also does not affect the ability to execute stored programs or views that have a DEFINER attribute naming the locked account. For nonupgraded installations that have no account_locked column, the server treats all accounts as unlocked, and using ... MySQL supports locking and unlocking user accounts using the ACCOUNT LOCK and ACCOUNT UNLOCK clauses for the CREATE USER and ALTER USER statements: When used with CREATE USER, these clauses specify the initial locking state for a new ...
https://dev.mysql.com/doc/refman/8.0/en/adding-collation.html
Every character set has at least one collation, and most have two or more collations. All existing character sets already have a binary collation, so there is no need here to describe how to add one. Warning User-defined collations are deprecated; ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-examples.html
If it is important to have the same order on the source and replica, the rows must be ordered before assigning an AUTO_INCREMENT number. For NDB tables, it is also possible to change the storage type used for a table or column. row ...
https://dev.mysql.com/doc/refman/8.0/en/arithmetic-functions.html
This means that you should avoid using - on integers that may have the value of −263. Table 14.9 Arithmetic Operators Name Description %, MOD Modulo operator * Multiplication operator + Addition operator - Minus operator - Change the sign of the ...