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/mysql-cluster-online-operations.html
Tells the data nodes to drop the original table and then to rename the copy. 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 ... 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/log-destinations.html
You can atomically rename a log table (to perform log rotation, for example) using the following strategy: USE mysql; DROP TABLE IF EXISTS general_log2; CREATE TABLE general_log2 LIKE general_log; RENAME TABLE general_log TO general_log_backup, ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-what-is-new-7-5.html
ALGORITHM=INPLACE RENAME may now contain DDL operations in addition to the renaming. This setting can be controlled for individual tables by means of a PARTITION_BALANCE option (renamed from FRAGMENT_COUNT_TYPE in NDB 7.5.4) embedded in NDB_TABLE ...
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. To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system variable. The EVENT ...
https://dev.mysql.com/doc/refman/5.7/en/sql-prepared-statements.html
Using prepared statements with placeholders for parameter values has the following benefits: Less overhead for parsing the statement each time it is executed. Typically, database applications process large volumes of almost-identical statements, ...
https://dev.mysql.com/doc/refman/5.7/en/temporary-table-problems.html
Use ALTER TABLE instead: ALTER TABLE old_name RENAME new_name; You cannot refer to a TEMPORARY table more than once in the same query. Temporary tables created with CREATE TEMPORARY TABLE have the following limitations: TEMPORARY tables are ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-reference.html
If encryption is enabled, the function performs a log file rotation operation that renames the current log file, and begins a new log file encrypted with the password. For details about how the audit log plugin interprets the audit_log_file value ...
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. Partitioning-related clauses for ALTER TABLE can be used with partitioned tables for repartitioning, to add, drop, discard, ...
https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html
Renaming a table requires ALTER and DROP on the old table, CREATE, and INSERT on the new table. CREATE USER Enables use of the ALTER USER, CREATE USER, DROP USER, RENAME USER, and REVOKE ALL PRIVILEGES statements. ALTER may be used to subvert the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-auto-increment.html
Regardless of the method used to create and populate the copy having the AUTO_INCREMENT column, the final step is to drop the original table and then rename the copy: DROP t1; ALTER TABLE t2 RENAME t1; See also Section B.3.6.1, “Problems with ...