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/data-type-defaults.html
The ordering constraint also applies to the use of ALTER TABLE to reorder table columns. Examples: CREATE TABLE t1 ( i INT DEFAULT -1, c VARCHAR(10) DEFAULT '', price DOUBLE(16,2) DEFAULT 0.00 ); SERIAL DEFAULT VALUE is a special case. An expression ... Data type specifications can have explicit or implicit default ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog.html
Note that from MySQL 8.0.14, mysqlbinlog returns a suitable error if you attempt to read an encrypted binary log file directly, but older versions of mysqlbinlog do not recognise the file as a binary log file at all. The other option values are ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-command-options.html
This option is on by default, which enables database, table, and column name completion. --dns-srv-name=name Command-Line Format --dns-srv-name=name Type String Specifies the name of a DNS SRV record that determines the candidate hosts to use for ...
https://dev.mysql.com/doc/refman/8.0/en/ndb-restore-to-different-version.html
In such cases, it is necessary to alter any tables using utf8mb4_ai_ci so that they use a character set supported in the older version prior to performing the backup. Due to changes in how the MySQL Server and NDB handle table metadata, tables ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-single-multi.html
Before the introduction of online DDL, it was common practice to combine many DDL operations into a single ALTER TABLE statement. Because each ALTER TABLE statement involved copying and rebuilding the table, it was more efficient to make several ...
https://dev.mysql.com/doc/refman/8.0/en/ansi-diff-select-into-table.html
For example: INSERT INTO tbl_temp2 (fld_id) SELECT tbl_temp1.fld_order_id FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100; Alternatively, you can use SELECT ... The same syntax can also be used inside stored routines using cursors and local ...
https://dev.mysql.com/doc/refman/8.0/en/firewall-information-schema-tables.html
The following sections describe the INFORMATION_SCHEMA tables associated with MySQL Enterprise Firewall (see Section 8.4.7, “MySQL Enterprise Firewall”). These tables are available only if the appropriate firewall plugins are enabled.
https://dev.mysql.com/doc/refman/8.0/en/general-information-schema-tables.html
The following sections describe what may be denoted as the “general” set of INFORMATION_SCHEMA tables. These are the tables not associated with particular storage engines, components, or plugins.
https://dev.mysql.com/doc/refman/8.0/en/information-schema-administrable-role-authorizations-table.html
The ADMINISTRABLE_ROLE_AUTHORIZATIONS table (available as of MySQL 8.0.19) provides information about which roles applicable for the current user or role can be granted to other users or roles. The ADMINISTRABLE_ROLE_AUTHORIZATIONS table has these ...GRANTEE The user name part of the account to which the role is ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-applicable-roles-table.html
The APPLICABLE_ROLES table (available as of MySQL 8.0.19) provides information about the roles that are applicable for the current user. The APPLICABLE_ROLES table has these columns: USER The user name part of the current user account. IS_GRANTABLE ...GRANTEE The user name part of the account to which the role is ...