PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/create-table.html
LIKE to create an empty table based on the definition of another table, including any column attributes and indexes defined in the original table: CREATE TABLE new_tbl LIKE orig_tbl; For more information, see Section 13.1.18.3, “CREATE TABLE ... | ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-online-operations.html
row *************************** Level: Warning Code: 1478 Message: Converted FIXED field 'c2' to DYNAMIC to enable online ADD COLUMN 1 row in set (0.00 sec) Columns are not converted from FIXED to DYNAMIC column format by renaming operations. Tells ... MySQL NDB Cluster 7.5 and 7.6 support online table schema changes using ALTER TABLE ...
https://dev.mysql.com/doc/refman/5.7/en/added-deprecated-removed.html
group_replication_auto_increment_increment: Determines interval between successive column values for transactions executing on this server. Options and Variables Introduced in MySQL 5.7 Options and Variables Deprecated in MySQL 5.7 Options and ...
https://dev.mysql.com/doc/refman/5.7/en/query-log.html
To rename the file and create a new one, use the following commands: $> mv host_name.log host_name-old.log $> mysqladmin flush-logs general $> mv host_name-old.log backup-directory On Windows, use rename rather than mv. You can also rename the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-what-is-new-7-5.html
The config_params table has been made read-only, and has been enhanced with additional columns providing information about each configuration parameter, including the parameter's type, default value, maximum and minimum values (where applicable), a ... Major changes and new features in NDB Cluster 7.5 which are likely to be of interest are shown in the following list: ndbinfo ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-restore.html
The following changes in primary key definitions are supported by --allow-pk-changes: Extending the primary key: A non-nullable column that exists in the table schema in the backup becomes part of the table's primary key in the database. Important ... The NDB Cluster restoration program is implemented as a separate command-line utility ndb_restore, which can normally be found in the MySQL bin ...
https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html
Summary of Available Privileges Privilege Descriptions Privilege-Granting Guidelines Summary of Available Privileges The following table shows the privilege names used in GRANT and REVOKE statements, along with the column name associated with each ... The privileges granted to a MySQL account determine which operations the account can ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-partition-operations.html
This option can be combined with other ALTER TABLE options such as those used to add, drop, or rename columns or indexes. To upgrade a KEY partitioned table that was created in MySQL 5.1, first execute SHOW CREATE TABLE and note the exact columns ...
https://dev.mysql.com/doc/refman/5.7/en/events-privileges.html
An event is not migrated or dropped as a result of renaming or dropping the user who created it. Users' EVENT privileges are stored in the Event_priv columns of the mysql.user and mysql.db tables. In both cases, this column holds one of the values ... To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html
SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME LIKE '%#sql%'; To remove an orphan intermediate table, perform the following steps: In the database directory, rename the #sql-*.frm file to match the base name of the orphan intermediate ... Information about table definitions is stored both in the .frm files, and in the InnoDB data ...