MySQL Memory 存储引擎浅析(5)

    PRIMARY KEY (id)

) ENGINE=INNODB;

/******************************************************

2.MYISAM

******************************************************/

DROP TABLE IF EXISTS test_myisam;

CREATE TABLE IF NOT EXISTS test_myisam (

    id                    INT UNSIGNED AUTO_INCREMENT                                COMMENT 'PK',

    obj                    CHAR(255) NOT NULL DEFAULT ''                            COMMENT 'OBJECT',

    PRIMARY KEY (id)

) ENGINE=MYISAM;

/******************************************************

1.MEMORY

******************************************************/

DROP TABLE IF EXISTS test_memory;

CREATE TABLE IF NOT EXISTS test_memory (

    id                    INT UNSIGNED AUTO_INCREMENT                                COMMENT 'PK',

    obj                    CHAR(255) NOT NULL DEFAULT ''                            COMMENT 'OBJECT',

    PRIMARY KEY (id)

) ENGINE=MEMORY;

测试代码：

using System;

using System.Data;

using MySql.Data.MySqlClient;

namespace MySqlEngineTest

{

    class Program

    {

        const string OBJ = "The MEMORY storage engine creates tables with contents that are stored in memory. Formerly, these were known as HEAP tables. MEMORY is the preferred term, although HEAP remains supported for backward compatibility.";

        const string SQL_CONN = "Data Source=127.0.0.1;Port=3308;User ID=root;Password=root;DataBase=test;Allow Zero Datetime=true;Charset=utf8;pooling=true;";