编辑代码

create database test;
use test;
create table student (
	id int primary key auto_increment,
	name varchar(255),
	age varchar(255),
	sss varchar(255),
    ssr  int
);

alter table student add sex varchar(255) after name;
alter table student change sss classname varchar(255);
alter table student drop ssr;


insert into student values (1, '姚', '男', 20, '计科2107');
insert into student values (2, '育',  '女', 21, '计科2106');
insert into student values (3, '航',  '男', 22, '计科2105');
insert into student(name) values('你好');
insert into student(id,age) values(6,11);

update student set sex='女' where id=3;
update student set sex='女',classname='计科' where id =1;

delete from student where id = 6;

select name,age from student;
select * from student where id=1;
select * from student;