MySQL RAM Tables

SELECT TABLE_NAME FROM `information_schema`.`partitions` WHERE `TABLE_SCHEMA` = 'TABLNAME' and `TABLE_NAME` LIKE 'ram_%'

1	SELECT TABLE_NAME FROM `information_schema`.`partitions` WHERE `TABLE_SCHEMA` = 'TABLNAME' and `TABLE_NAME` LIKE 'ram_%'

DROP TABLE IF EXISTS `ram_test`

1	DROP TABLE IF EXISTS `ram_test`

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;

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;

INSERT INTO `ram_test` SELECT * FROM `test`

1	INSERT INTO `ram_test` SELECT * FROM `test`

Thomas Eses

WEBDEVELOPER – PHP, JavaScript, Datenbanken…

Kategorie Tags:

Folgende Artikel könnten auch interessieren