MySQL RAM Tables
|
1 |
SELECT TABLE_NAME FROM `information_schema`.`partitions` WHERE `TABLE_SCHEMA` = 'TABLNAME' and `TABLE_NAME` LIKE 'ram_%' |
|
1 |
DROP TABLE IF EXISTS `ram_test` |
|
1 2 3 4 |
CREATE TABLE `ram_test` ( `fieldA` varchar(100) DEFAULT NULL, `fieldB` varchar(100) DEFAULT NULL, ) ENGINE=Memory DEFAULT CHARSET=utf8 PACK_KEYS=0 ROW_FORMAT=COMPACT; |
|
1 |
INSERT INTO `ram_test` SELECT * FROM `test` |
Weiterlesen