#创建语句
create table student(
no tinyint(2) primary key,
stuNo int(10) not null,
stuName varchar(32),
stuClass varchar(32)
);
#增加字段
alter table student add score int(10);
#修改字段
alter table student modify score int(12);
#删除字段
alter table student drop column score;
#删除记录
delete from student where no=1;
#清除表
drop table student;
#插入语句
insert into student values(1,1001,'ly','english',80);
create table student(
no tinyint(2) primary key,
stuNo int(10) not null,
stuName varchar(32),
stuClass varchar(32)
);
#增加字段
alter table student add score int(10);
#修改字段
alter table student modify score int(12);
#删除字段
alter table student drop column score;
#删除记录
delete from student where no=1;
#清除表
drop table student;
#插入语句
insert into student values(1,1001,'ly','english',80);