Usage of Memory Engine in MySQL:
Usage of Memory Engine in MySQL:
Memory is one of the Storage Engine used in MySQL. It is hash based memory engine is used to store table.
It stored in memory. Mainly, it is useful to store temporary tables. On creating a table itself we specified the engine, i.e our created table where to be store in the database.
Example:
CREATE TABLE t1 (msgid INT NOT NULL AUTO_INCREMENT PRIMARY KEY, message CHAR(20)) ENGINE=MEMORY;
here, the table t1 is created in the memory, from memory itself. we can insert,updation and retrieving operations are performed.
