立即学习:https://edu.csdn.net/course/play/4364/77177?utm_source=blogtoedu
# MYISAM
create table student
(
studentid int,
sname varchar(10),
cardID varchar(20),
address varchar(20),
mobile char(11)
) engine=myisam
# insert语句可以插入多条数据
insert student values (5, '韩立纲', '202939384412221323', '石家庄', '12232294843'),
(3, '文文', '202939384412223323', '石家庄', '12232244843'),
(9, '韩可可', '202939384412098323', '石家庄', '12232194843' )
# 显示查询计划
explain select * from student where studentid=9
alter table student add primary key(studentid)
alter table student engine=innoDB