除student

drop table student

//創(chuàng)建數(shù)據(jù)庫表-學生成績表

create table student(id int primary key auto_increment,name varchar(20) unique not null,chinese float,english float,math float);

//添加幾條數(shù)據(jù)

insert into student values(1,’張三’,90,80,80);

insert into student values(2,’李四’,90,87,60);

insert into student values(3,’王五’,70,60,69);