编辑代码

create database text;
use text;

create table student(
    id int,
    num varchar(10),
    age int,
    sss varchar(255),
    ssr int,
);
alter table student add sex varchar(10) after name;
alter table student change sss classmane values(255);
alter table student drop ssr;

insert into student values(1,'姚','男','22','计科2105')
insert into student values(2,'育','女','23','计科2106')
insert into student values(3,'航','男','24','计科2107')

select id=3 from student;
select * from student;