Valid 1Z0-888 Dumps shared by ExamDiscuss.com for Helping Passing 1Z0-888 Exam! ExamDiscuss.com now offer the newest 1Z0-888 exam dumps, the ExamDiscuss.com 1Z0-888 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 1Z0-888 dumps with Test Engine here:
Access 1Z0-888 Dumps Premium Version
(155 Q&As Dumps, 35%OFF Special Discount Code: freecram)
<< Prev Question Next Question >>
Question 25/49
old_alter_tableis disabled as shown.
mysql> SELECT @@old_alter_table;
Consider this statement on a RANGE-partitioned table:
mysql> ALTER TABLE orders DROP PARTITION p1, p3;
What is the outcome of executing this statement?
mysql> SELECT @@old_alter_table;
Consider this statement on a RANGE-partitioned table:
mysql> ALTER TABLE orders DROP PARTITION p1, p3;
What is the outcome of executing this statement?
Recent Comments (The most recent comments are at the top.)
Because of this, you must have the DROP privilege for a table before you can execute ALTER TABLE ... DROP PARTITION on that table.
If you wish to drop all data from all partitions while preserving the table definition and its partitioning scheme, use the TRUNCATE TABLE statement. (See Section 13.1.34, “TRUNCATE TABLE Statement”.)
If you intend to change the partitioning of a table without losing data, use ALTER TABLE ... REORGANIZE PARTITION instead. See below or in Section 13.1.8, “ALTER TABLE Statement”, for information about REORGANIZE PARTITION.