Which two statements are true regarding partitioning in Mysql?
A.
Tables with BLOB and TEXT columns cannot be partitioned.
B.
Partitioning allows easier management of smaller data sets for certain queries.
C.
Partitioning allows different columns to be stored in separate files.
D.
The partitioning expression is an integer or function that returns an integer value or NULL
value.
E.
Partitioning is only available for those storage engines that implements it natively.
B,E
B,D
B,D
B,D
B E
E cause . some storage Engine do not use partitioning
CREATE TABLE tm1 (
s1 CHAR(32) PRIMARY KEY
)
PARTITION BY KEY(s1)
PARTITIONS 10;
so,E is wrong;
sorry ,d is wrong