02. 关于存储引擎
-- 1. 查看引擎 SHOW ENGINES; -- 2. 修改默认引擎 -- 修改my.ini 后重启 -- default-storage-engine=INNODB 增删较好 -- default-storage-engine=MYISAM 支持全文索引,查询较好 USE xxxcompany; SET default_storge_engine = INNODB; SET default_storge_engine = MYISAM; -- 3.指定表格使用引擎 CREATE TABLE student (stuId INT,stuName VARCHAR(20)); CREATE TABLE student (stuId INT,stuName VARCHAR(20)) ENGINE = MYISAM; DROP TABLE student; SHOW CREATE TABLE student;