编辑代码

-- 创建数据库jwgl
create database jwgl;
-- 选择jwgl数据库
use jwgl;

create table student(
    id int,
    name varchar(10)
);

insert into student values (11,'zhangsan1');
select *from student;
alter table student add column tel int;
alter table student modify name char(20);
alter table student drop tel;
alter table student change id ID int;
alter table student rename to stu;
drop table stu;
-- desc student;