Which three statements are characteristic of the MEMORY storage engine?
A.
It can support transactions
B.
Table contents are not saved if the server is restarted.
C.
It cannot contain text or BLOB columns.
D.
It can support foreign keys.
E.
Each table is represented on disk as an.frm file.
F.
Each table has a corresponding.MYI and .MYD file.
B,C,E
BCE
mysql> show create table t4 \G
*************************** 1. row ***************************
Table: t4
Create Table: CREATE TABLE `t4` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`c1` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MEMORY AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 KEY_BLOCK_SIZE=368
1 row in set (0.00 sec)
mysql>
you create table including text type column, why?