mysql -uroot -p123456
use class;
alter table student add credut int;
update student set credit=0 where sno=2017001;
update student set credit=0 where sno=2017002;
alter table course add xuefen int;
update course set xuefen=1.5 where cno=1;
update course set xuefen=1 where cno=2;
update course set xuefen=2 where cno=3;
delimiter &&
crete procedure sp_1(in xuehao int)
begin
delete from student where sno=xuehao;
end
&&
delimiter ;