Home › SQL › MySQL › Put a table into memory

Put a table into memory

May 17, 2010 - 8:16pm — Xuan Ngo 

CREATE TABLE new_table ENGINE=MEMORY AS SELECT * FROM old_table;