创建表并指定类型

#创建subject表(设置表类型为myisam类型)CREATE TABLE IF NOT EXISTS SUBJECT(SubjectNo INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT COMMENT '课程编号',SubjectName VARCHAR(50)COMMENT '课程名称',ClassHour INT(4) COMMENT '学时',gradeId INT(4) COMMENT '年级编号')ENGINE=MYISAM SELECT * FROM SUBJECT;SHOW ENGINES;