create table tb_student4(
stu_num char(9) primary key,
name char(20),
school char(10)
) engine innodb;
create table tb_inf_student4(
stu_num char(9),
address char(64),
constraint foreign key(stu_num) references tb_student4(stu_num)
)engine innodb;
create table tb_student5(
stu_num char(9) primary key,
name char(20),
school char(10)
) engine MyISAM;
create table tb_inf_student5(
stu_num char(9),
address char(64),
constraint foreign key(stu_num) references tb_student4(stu_num)
)engine MyISAM;
MySQL 默认存储引擎
InnoDB 是系统的默认引擎,支持可靠的事务处理。
使用下面的语句可以修改数据库临时的默认存储引擎
SET default_storage_engine=< 存储引擎名 >