编辑代码

show DATABASES;
CREATE DATABASE test; 
show DATABASES;
use test;
CREATE TABLE student(
   YJSBH int not null,
   zhigonghao int,
   xingming varchar(30),
   zhicheng varchar(30),
   xingbie varchar(1),
   nianning varchar(30),
   primary key(YJSBH,zhigonghao)
);
INSERT INTO student VALUES(1,1,'张一','经理','男','25');
INSERT INTO student VALUES(2,12,'张二','主管','男','30');
INSERT INTO student VALUES(3,123,'张三','主任','男','25');
delete from student where YJSBH=3;

update student set zhicheng='总管' where YJSBH=2;
insert into student(YJSBH,zhigonghao,xingming,zhicheng,xingbi,nianning )
values(4,1234,'张五','男','实习生','20');
SELECT   *  FROM  student;

alter table  student add  zhuchezhibeng varchar(30);
desc student;

alter table student MODIFY zhicheng varchar(40);
desc student;

alter table student CHANGE xingming zhigongxingming varchar(40);
desc student;

SELECT * from student where mingcheng like '张%';
update student set zhuchezhibeng='5000元' where YJSBH=1;