PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/connection-compression-control.html
Configuration parameters that enable specifying compression algorithms are string-valued and take a list of one or more comma-separated compression algorithm names, in any order, chosen from the following items (not case-sensitive): zlib: Permit ...
https://dev.mysql.com/doc/refman/8.0/en/connection-control-plugin-installation.html
Thus, to make the changes required for some configurations, you might need to set the variables in a specific order. This section describes how to install the connection control plugins, CONNECTION_CONTROL and ...
https://dev.mysql.com/doc/refman/8.0/en/connection-options.html
These mode values are permissible, in order of increasing strictness: DISABLED: Establish an unencrypted connection. This section describes options supported by most MySQL client programs that control how client programs establish connections to ...
https://dev.mysql.com/doc/refman/8.0/en/create-logfile-group.html
You may optionally follow either or both of these with a one-letter abbreviation for an order of magnitude, similar to those used in my.cnf. CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-select.html
You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl; MySQL creates new columns for all elements in the SELECT. For example: mysql> CREATE ...
https://dev.mysql.com/doc/refman/8.0/en/create-tablespace.html
When setting EXTENT_SIZE or INITIAL_SIZE, you may optionally follow the number with a one-letter abbreviation for an order of magnitude, similar to those used in my.cnf. The precise syntax and semantics depend on the storage engine used. MySQL NDB ...
https://dev.mysql.com/doc/refman/8.0/en/creating-accounts.html
The reason for this is that the anonymous-user account has a more specific Host column value than the 'finley'@'%' account and thus comes earlier in the user table sort order. To manage MySQL accounts, use the SQL statements intended for that ...
https://dev.mysql.com/doc/refman/8.0/en/data-type-defaults.html
The ordering constraint also applies to the use of ALTER TABLE to reorder table columns. Data type specifications can have explicit or implicit default values. A DEFAULT value clause in a data type specification explicitly indicates a default value ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html
mysql> SELECT TIMESTAMPDIFF(MONTH,'2003-02-01','2003-05-01'); -> 3 mysql> SELECT TIMESTAMPDIFF(YEAR,'2002-05-01','2001-01-01'); -> -1 mysql> SELECT TIMESTAMPDIFF(MINUTE,'2003-02-01','2003-05-01 12:05:55'); -> 128885 Note The order of the date or ...
https://dev.mysql.com/doc/refman/8.0/en/datetime.html
This section describes their characteristics, how they are similar, and how they differ. MySQL recognizes DATE, DATETIME, and TIMESTAMP values in several formats, described in Section 11.1.3, “Date and Time Literals”. For the DATE and DATETIME ...