1. 查看存储引擎

  show engines;

2. 查看数据存储位置

  show variables like ‘datadir‘；

3. 存储引擎

 create table mytest engine=myisam as select * from salaries;

 alter table mytest engine=innodb;

mysql 基本命令操作