MySQL中创建表指定存储引擎

时间：2017-11-11 17:14:52 收藏：0 阅读：1317

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

原文：http://www.cnblogs.com/danawill/p/7819320.html