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