drop table stu_student;
drop table stu_users;
drop table tea_teacher;
create table stu_student(
stu_num char(10) not null,
stu_name char(20) not null,
stu_sex char(2),
stu_address char(30),
stu_grade char(8)
);
create table stu_users(
id char(10) not null,
username char(20) not null,
userpw char(20) not null
);
create table tea_teacher(
tea_num char(10) not null,
tea_name char(20) not null,
tea_sex char(2),
tea_address char(30),
);
insert into stu_student values('0001','周伟','男','聊城','5');
insert into stu_student values('0002','陈伟','男','泰安','6');
insert into stu_student values('0003','样钟响','男','费县','7');
insert into stu_student values('0004','郭富城','男','香港','8');
insert into stu_users values('0001','adm','aaa');
insert into tea_teacher values('0001','邓伟','男','聊城');
insert into tea_teacher values('0001','张三','男','聊城');
insert into tea_teacher values('0001','李四','男','聊城');