mysql 把表放到内存中_如何将MySQL表结构复制到内存中的表？

CREATE TABLE t_copy ENGINE=MEMORY SELECT * FROM t_original;

我实际上尝试过它,它的工作原理！

mysql> show create table queue\G

*************************** 1. row ***************************

Table: queue

Create Table: CREATE TABLE `queue` (

`ndx` int(11) NOT NULL AUTO_INCREMENT,

`folderid` int(11) NOT NULL,

PRIMARY KEY (`ndx`)

) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1

1 row in set (0.02 sec)

mysql> create table queue_memory engine=MEMORY as select * from queue;

Query OK, 0 rows affected (0.05 sec)

Records: 0 Duplicates: 0 Warnings: 0

lwdba@localhost (DB test) :: show create table queue_memory\G

*************************** 1. row ***************************

Table: queue_memory

Create Table: CREATE TABLE `queue_memory` (

`ndx` int(11) NOT NULL DEFAULT '0',

`folderid` int(11) NOT NULL

) ENGINE=MEMORY DEFAULT CHARSET=latin1

1 row in set (0.00 sec)

试试看 ！！！