MySQL第十二次作业-存储过程的应用

create table chenminchao_stu(
id int(10) not null unique primary key,
name varchar(50) not null,
class varchar(50) not null
);

insert into chenminchao_stu values
(‘1’,‘Lucy’,‘class1’),
(‘2’,‘Tom’,‘class1’),
(‘3’,‘Rose’,‘class2’);

desc chenminchao_stu;

select * from chenminchao_stu;