Tables Using MEMORY Storage Engine in MySQL

Q

How To Create a New Table Using the MEMORY Storage Engine in MySQL?

✍: FYIcenter.com

A

MEMORY storage engine stores table data in computer system memory. This is good for creating temporary tables.

MEMORY is not the default storage engine. You need to specify "ENGINE = MEMORY" at the end of the "CREATE TABLE" statement to create new tables with the MEMORY storage engine. The tutorial exercise below shows you a good example:

>cd \mysql\bin
>mysql -u dev -piyf fyi

mysql> CREATE TABLE fyi_memory (
  id INTEGER PRIMARY KEY,
  title VARCHAR(80), 
  count INTEGER )
  ENGINE = MEMORY;
Query OK, 0 rows affected, 1 warning (0.07 sec)

mysql> SHOW CREATE TABLE fyi_memory;
  CREATE TABLE `fyi_memory` (
  `id` int(11) NOT NULL,
  `title` varchar(80) default NULL,
  `count` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MEMORY DEFAULT CHARSET=latin1 
1 row in set (0.02 sec)

 

Storage Engines: MyISAM, InnoDB and BDB in MySQL

⇒⇒MySQL Database Tutorials

2017-08-08, 329👍, 0💬