MySQL 存储引擎之Memory

> CREATE TABLE test(id int,name varchar(10)) ENGINE=MEMORY; Query OK, 0 rows affected (0.11 sec) mysql> insert into test values(1,‘a‘); Query OK, 1 row affected (0.01 sec) mysql> insert into test values(2,‘b‘); Query OK, 1 row affected (0.01 sec) mysql> select * from temp; Empty set (0.01 sec) mysql> select * from test; +------+------+ | id | name | +------+------+ | 1 | a | | 2 | b | +------+------+ 2 rows in set (0.01 sec) mysql> exit; Bye

[root@mysql-master ~]# /etc/init.d/mysql.server restart 
Shutting down MySQL.... SUCCESS! 
Starting MySQL.. SUCCESS! 
[root@mysql-master ~]# mysql -u root -p
mysql> use course;
Database changed

mysql> select * from test;
Empty set (0.00 sec)

mysql> desc test;
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| id    | int(11)     | YES  |     | NULL    |       |
| name  | varchar(10) | YES  |     | NULL    |       |
+-------+-------------+------+-----+---------+-------+
2 rows in set (0.01 sec)

 

MySQL 存储引擎之Memory

标签：存储引擎   key   hang   database   也会   type   int   内存   har