1. 查看存储引擎
show engines;
2. 查看数据存储位置
show variables like 'datadir'；
3. 存储引擎
create table mytest engine=myisam as select * from salaries;
alter table mytest engine=innodb;
mysql 基本命令操作
2023-01-30 18:30:23
2023-01-30 18:30:23
1. 查看存储引擎
show engines;
2. 查看数据存储位置
show variables like 'datadir'；
3. 存储引擎
create table mytest engine=myisam as select * from salaries;
alter table mytest engine=innodb;