编辑代码

CREATE DATABASE test;
use test;
CREATE TABLE student (
	id int AUTO_INCREMENT PRIMARY KEY,
	name varchar(255),
	sex char(1),
	dtdate  date,
    classname varchar(255),
    email varchar(255)
);
alter TABLE student add sro int;
alter TABLE student add sro1 int first;
alter TABLE student add age int after id;
alter TABLE student change  sro sss int;
alter TABLE student drop sro1;


INSERT INTO student VALUES (1, 20,'刘一', '男', '2021-09-01','计科2105班','280587@qq.com',30);
INSERT INTO student VALUES (2,21,'陈二',  '女', now(),'计科2105班','280587@qq.com',31);
INSERT INTO student VALUES (3,22,'张三',  '男', now(),'计科2105班','280587@qq.com',32);
INSERT INTO student VALUES (4,23,'李四',  '男', now(),'计科2105班','280587@qq.com',33);

INSERT INTO student(name) VALUES('姚');
INSERT INTO student(name,age) VALUES('育',24);

update student set age=23 where id=5;
update student set age=18,name='你好' where id=1 and sex='男';

delete from student where id=4; 

SELECT age,name from   student;
SELECT * from student where id=2;

SELECT * FROM student;