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/innodb-table-import.html
Otherwise, the table must be created on the same MySQL server instance into which it is being imported. If the table was created in an external directory by specifying the DATA DIRECTORY clause in the CREATE TABLE statement, the table that you ...As ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-check-constraints.html
Prior to MySQL 8.0.16, CREATE TABLE permits only the following limited version of table CHECK constraint syntax, which is parsed and ignored: CHECK (expr) As of MySQL 8.0.16, CREATE TABLE permits the core features of table and column CHECK ...If ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-what-is-new.html
It is also no longer possible to issue a CREATE TABLE statement that refers to a nonexistent tablespace. This means that NDB tables created in NDB Cluster 8.0 are not compatible with previous NDB Cluster releases. Tables created in previous releases ...NDB 8.0 removes the previous 63-byte limit on identifiers for databases and ... The following sections describe changes in the implementation of MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-restore.html
Such an index is created only when necessary to apply events from the backup log to a table which has an extended primary key. This index is named NDB$RESTORE_PK_MAPPING, and is created on each table requiring it; it can be shared, if necessary, by ...This program reads the files created as a result of the backup and inserts the stored information into the ... The NDB Cluster restoration program is ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html
To work around this issue, use the --result-file option, which creates the output in ASCII format: mysqldump [options] --result-file=dump.sql It is not recommended to load a dump file when GTIDs are enabled on the server (gtid_mode=ON), if your dump ... The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-secondary-indexes.html
A secondary index may be created on one or more virtual columns or on a combination of virtual columns and regular columns or stored generated columns. When a secondary index is created on a virtual generated column, generated column values are ...A ...
https://dev.mysql.com/doc/refman/8.0/en/creating-accounts.html
To manage MySQL accounts, use the SQL statements intended for that purpose: CREATE USER and DROP USER create and remove accounts. Account-management statements cause the server to make appropriate modifications to the underlying grant tables, which ...GRANT and REVOKE assign privileges to and revoke privileges from ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management-exchange.html
In addition to the ALTER, INSERT, and CREATE privileges usually required for ALTER TABLE statements, you must have the DROP privilege to perform ALTER TABLE ... In addition, both tables must use the same storage engine: mysql> CREATE TABLE es3 LIKE ...Table nt contains no foreign key references, and no other table has any foreign keys that refer to ...
https://dev.mysql.com/doc/refman/8.0/en/grant-tables.html
This change of grant table storage engine enables an accompanying change to the behavior of account-management statements such as CREATE USER or GRANT. For example, the 'root'@'localhost' account created during MySQL installation has a row in the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-ssl-rsa-setup.html
This program creates the SSL certificate and key files and RSA key-pair files required to support secure connections using SSL and secure password exchange using RSA over unencrypted connections, if those files are missing. mysql_ssl_rsa_setup can ...Instead, consider using MySQL server to generate missing SSL and RSA files automatically at startup (see Automatic SSL and RSA File ...