编辑代码

show DATABASES;
CREATE DATABASE test; 
show DATABASES;
use test;
CREATE TABLE student(
   YJSBH int primary key not null,

   mingcheng varchar(30),
   dizhi varchar(30)
   
);
INSERT INTO student VALUES(1,'米猪厂','北京');
INSERT INTO student VALUES(2,'米鹅厂','杭州');
INSERT INTO student VALUES(3,'米忽悠','上海');
delete from student where YJSBH=3;

update student set dizhi='苏州' where YJSBH=2;
insert into student(YJSBH,mingcheng,dizhi)
values(4,'intel','纽约');
SELECT   *  FROM  student;

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

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

alter table student CHANGE dizhi gongshidizhi varchar(40);
desc student;

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