MySQL中创建表指定存储引擎

来源:转载

create table test(
id int(10) unsigned not null auto_increment,
name varchar(10) character set utf8,
age int(10),
primary key(id)
)
engine=MyISAM

create table test(
id int(10) unsigned not null auto_increment,
name varchar(10) character set utf8,
age int(10),
primary key(id)
)
engine=MEMORY

create table test(
id int(10) unsigned not null auto_increment,
name varchar(10) character set utf8,
age int(10),
primary key(id)
)
engine=INNODB

分享给朋友:
您可能感兴趣的文章:
随机阅读: